1297:
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
1508:
1509: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1510: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1511: regional_variance_name, REG_VARIANCE_COUNTRY_CODE
1512: from per_ri_config_jp_rv_v
1513: where configuration_code = cp_configuration_code
1514: and exists (select configuration_code
1515: from per_ri_config_pos_rv_seg_v
1516: where configuration_code = cp_configuration_code);