FORM 个性化职位获取职务序列LOV

实现目标：根据配置文件调整职务LOV内容

个性化设置：

获取配置文件的值：FND_PROFILE.VALUE('CUX_PER_MO_ABBR')

配置个性化条件

设置活动：创建记录组 ， 设置LOV对应的记录组

SELECT pjv.job_id,
       pjv.NAME,
       pjv.date_from job_start_date,
       pjv.date_to   job_end_date
FROM   per_jobs_v pjv ,
             per_job_definitions pjd
WHERE  pjv.business_group_id = :ctl_globals.business_group_id
AND pjd.job_definition_id = pjv.job_definition_id
AND    :positions.effective_start_date BETWEEN pjv.date_from AND nvl(pjv.date_to,:ctl_globals.end_of_time)
AND (CASE
       WHEN  FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFL',
                      'DFAC',
                      'DFCV',
                      'DFMHQ',
                      'DFSCV',
                      'DFYY') AND pjd.segment5  = '10' THEN 'Y'
       WHEN  FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFMSY',
                      'DFMXY',
                      'DFMED') AND pjd.segment5  = '20' THEN 'Y'
       WHEN  FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFTC') AND pjd.segment5  = '30' THEN 'Y'              
       WHEN  FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFM') AND pjd.segment5 IN ('10','20','30')THEN 'Y'
       ELSE 'N'
 END) = 'Y' 
 ORDER BY NAME