DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on PER_RI_CONFIG_JP_RV_V

Line 121: from per_ri_config_jp_rv_v

117: RETURN boolean IS
118:
119: cursor csr_jp_rv_defined (cp_configuration_code in varchar2) IS
120: select count(*)
121: from per_ri_config_jp_rv_v
122: where configuration_code = p_configuration_code;
123:
124: cursor csr_grd_rv_defined (cp_configuration_code in varchar2) IS
125: select count(*)

Line 207: from per_ri_config_jp_rv_v rv,

203:
204: cursor csr_job_rv (cp_configuration_code in varchar2
205: ,cp_bg_country_code in varchar2) IS
206: select rv.regional_variance_name
207: from per_ri_config_jp_rv_v rv,
208: per_ri_config_job_rv_seg_v seg
209: where rv.configuration_code = cp_configuration_code
210: and rv.reg_variance_country_code = p_bg_country_code
211: and rv.configuration_code = seg.configuration_code

Line 264: from per_ri_config_jp_rv_v

260:
261: cursor csr_pos_rv (cp_configuration_code in varchar2
262: ,cp_bg_country_code in varchar2) IS
263: select regional_variance_name
264: from per_ri_config_jp_rv_v
265: where configuration_code = p_configuration_code
266: and reg_variance_country_code = p_bg_country_code
267: and exists (select configuration_code
268: from per_ri_config_pos_rv_seg_v