DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_JOB_RV_SEG_V

Line 1302: per_ri_config_job_rv_seg_v seg

1298: cursor csr_config_jobs_rv (cp_configuration_code in varchar2) IS
1299: select distinct per_ri_config_utilities.return_config_entity_name(rv.regional_variance_name),
1300: rv.regional_variance_name, rv.REG_VARIANCE_COUNTRY_CODE
1301: from per_ri_config_jp_rv_v rv,
1302: per_ri_config_job_rv_seg_v seg
1303: where rv.configuration_code = cp_configuration_code
1304: and rv.configuration_code = seg.configuration_code
1305: and rv.regional_variance_name = seg.regional_variance_name
1306: and seg.global_structure_indicator = 'N';

Line 1313: from per_ri_config_job_rv_seg_v

1309: ,cp_jobs_rv_name in varchar2) IS
1310: select distinct segment_type
1311: ,segment_name
1312: ,CONFIG_SEQUENCE
1313: from per_ri_config_job_rv_seg_v
1314: where configuration_code = cp_configuration_code
1315: and regional_variance_name = cp_jobs_rv_name
1316: order by CONFIG_SEQUENCE;
1317: