APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_COMPONENT_USAGES

Line 182: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

178: return varchar2
179: is
180: --
181: l_dummy number;
182: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
183: --
184: begin
185: select 1
186: into l_dummy

Line 204: from pay_retro_component_usages prcu

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
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

Line 241: proc_type pay_retro_component_usages.reprocess_type%type;

237: p_source_type in varchar2
238: )
239: return varchar2
240: is
241: proc_type pay_retro_component_usages.reprocess_type%type;
242: begin
243: --
244: proc_type := get_reprocess_type(p_entry_id,
245: p_element_type_id,

Line 274: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

270: return varchar2
271: is
272: --
273: l_dummy number;
274: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
275: --
276: begin
277: --
278: l_reprocess_type := get_reprocess_type(p_entry_id,

Line 331: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

327: return varchar2
328: is
329: --
330: l_dummy number;
331: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
332: --
333: begin
334: --
335: /* If no retro component is supplied then it must be

Line 492: pay_retro_component_usages prcu,

488: --
489: select pesu.retro_element_type_id
490: into l_retro_ele_type_id
491: from pay_element_span_usages pesu,
492: pay_retro_component_usages prcu,
493: pay_time_spans pts
494: where prcu.retro_component_id = p_retro_comp_id
495: and prcu.creator_id = p_element_type_id
496: and prcu.creator_type = 'ET'

Line 536: pay_retro_component_usages prcu,

532: */
533: select pesu.retro_element_type_id
534: into l_retro_ele_type_id
535: from pay_element_span_usages pesu,
536: pay_retro_component_usages prcu,
537: pay_time_spans pts
538: where prcu.retro_component_id = p_retro_comp_id
539: and prcu.creator_id = p_element_type_id
540: and prcu.creator_type = 'ET'