APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_COMPONENT_USAGES

Line 198: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

194: return varchar2
195: is
196: --
197: l_dummy number;
198: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
199: --
200: begin
201: select 1
202: into l_dummy

Line 220: from pay_retro_component_usages prcu

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

Line 257: proc_type pay_retro_component_usages.reprocess_type%type;

253: p_source_type in varchar2
254: )
255: return varchar2
256: is
257: proc_type pay_retro_component_usages.reprocess_type%type;
258: begin
259: --
260: proc_type := get_reprocess_type(p_entry_id,
261: p_element_type_id,

Line 290: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

286: return varchar2
287: is
288: --
289: l_dummy number;
290: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
291: --
292: begin
293: --
294: l_reprocess_type := get_reprocess_type(p_entry_id,

Line 347: l_reprocess_type pay_retro_component_usages.reprocess_type%type;

343: return varchar2
344: is
345: --
346: l_dummy number;
347: l_reprocess_type pay_retro_component_usages.reprocess_type%type;
348: --
349: begin
350: --
351: /* If no retro component is supplied then it must be

Line 512: pay_retro_component_usages prcu,

508: --
509: select pesu.retro_element_type_id
510: into l_retro_ele_type_id
511: from pay_element_span_usages pesu,
512: pay_retro_component_usages prcu,
513: pay_time_spans pts
514: where prcu.retro_component_id = p_retro_comp_id
515: and prcu.creator_id = p_element_type_id
516: and prcu.creator_type = 'ET'

Line 556: pay_retro_component_usages prcu,

552: */
553: select pesu.retro_element_type_id
554: into l_retro_ele_type_id
555: from pay_element_span_usages pesu,
556: pay_retro_component_usages prcu,
557: pay_time_spans pts
558: where prcu.retro_component_id = p_retro_comp_id
559: and prcu.creator_id = p_element_type_id
560: and prcu.creator_type = 'ET'