APPS.PAY_RETRO_PKG dependencies on PAY_PROC_ENVIRONMENT_PKG

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

195: when no_data_found then
196: --
197: begin
198: --
199: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
200: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
201:
202: select prcu.reprocess_type
203: into l_reprocess_type

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

196: --
197: begin
198: --
199: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
200: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
201:
202: select prcu.reprocess_type
203: into l_reprocess_type
204: from pay_retro_component_usages prcu

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

204: from pay_retro_component_usages prcu
205: where prcu.retro_component_id = p_retro_comp_id
206: and prcu.creator_id = p_element_type_id
207: and prcu.creator_type = 'ET'
208: and (( prcu.business_group_id = pay_proc_environment_pkg.bgid
209: and prcu.legislation_code is null)
210: or
211: ( prcu.legislation_code = pay_proc_environment_pkg.legc
212: and prcu.business_group_id is null)

Line 211: ( prcu.legislation_code = pay_proc_environment_pkg.legc

207: and prcu.creator_type = 'ET'
208: and (( prcu.business_group_id = pay_proc_environment_pkg.bgid
209: and prcu.legislation_code is null)
210: or
211: ( prcu.legislation_code = pay_proc_environment_pkg.legc
212: and prcu.business_group_id is null)
213: or
214: ( prcu.legislation_code is null
215: and prcu.business_group_id is null)