APPS.PAY_RETRO_PKG dependencies on PAY_PROC_ENVIRONMENT_PKG

Line 215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));

211: when no_data_found then
212: --
213: begin
214: --
215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
217:
218: select prcu.reprocess_type
219: into l_reprocess_type

Line 216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);

212: --
213: begin
214: --
215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
217:
218: select prcu.reprocess_type
219: into l_reprocess_type
220: from pay_retro_component_usages prcu

Line 224: and (( prcu.business_group_id = pay_proc_environment_pkg.bgid

220: from pay_retro_component_usages prcu
221: where prcu.retro_component_id = p_retro_comp_id
222: and prcu.creator_id = p_element_type_id
223: and prcu.creator_type = 'ET'
224: and (( prcu.business_group_id = pay_proc_environment_pkg.bgid
225: and prcu.legislation_code is null)
226: or
227: ( prcu.legislation_code = pay_proc_environment_pkg.legc
228: and prcu.business_group_id is null)

Line 227: ( prcu.legislation_code = pay_proc_environment_pkg.legc

223: and prcu.creator_type = 'ET'
224: and (( prcu.business_group_id = pay_proc_environment_pkg.bgid
225: and prcu.legislation_code is null)
226: or
227: ( prcu.legislation_code = pay_proc_environment_pkg.legc
228: and prcu.business_group_id is null)
229: or
230: ( prcu.legislation_code is null
231: and prcu.business_group_id is null)