APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 381: l_creator_type pay_element_entries_f.creator_type%type;

377: p_date in date)
378: return number
379: is
380: --
381: l_creator_type pay_element_entries_f.creator_type%type;
382: --
383: begin
384: --
385: select creator_type

Line 387: from pay_element_entries_f

383: begin
384: --
385: select creator_type
386: into l_creator_type
387: from pay_element_entries_f
388: where element_entry_id = p_element_entry_id
389: and p_date between effective_start_date
390: and effective_end_date;
391: --

Line 619: from pay_element_entries_f pee

615: and paa_mret.object_type = paa_ret.object_type
616: and paa_mret.payroll_action_id = paa_ret.payroll_action_id
617: and paa_mret.source_action_id is null
618: and exists (select ''
619: from pay_element_entries_f pee
620: where pee.creator_id = paa_mret.assignment_action_id
621: and pee.creator_type in ('RR', 'EE', 'NR', 'PR')
622: and pee.assignment_id = paa_ret.assignment_id);
623: --

Line 642: from pay_element_entries_f pee

638: and paa_mret.object_type = paa_ret.object_type
639: and paa_mret.payroll_action_id = paa_ret.payroll_action_id
640: and paa_mret.source_action_id is null
641: and exists (select ''
642: from pay_element_entries_f pee
643: where pee.creator_id = paa_mret.assignment_action_id
644: and pee.creator_type in ('RR', 'EE', 'NR', 'PR')
645: and pee.assignment_id = paa_ret.assignment_id);
646: --

Line 784: pay_element_entries_f pee1

780: if (l_ovl_exists = 0) then
781: select count(*)
782: into l_matching_pr
783: from pay_entry_process_details pepd1,
784: pay_element_entries_f pee1
785: where pepd1.element_entry_id = p_element_entry_id
786: and pepd1.element_entry_id = pee1.element_entry_id
787: and exists
788: (select 'Y'

Line 790: pay_element_entries_f pee2

786: and pepd1.element_entry_id = pee1.element_entry_id
787: and exists
788: (select 'Y'
789: from pay_entry_process_details pepd2,
790: pay_element_entries_f pee2
791: where pee2.creator_type = 'PR'
792: and pee2.element_entry_id = pepd2.element_entry_id
793: and pee2.assignment_id = pee1.assignment_id
794: and pepd1.run_result_id = pepd2.run_result_id

Line 1439: FROM pay_element_entries_f pee,

1435: pepd.tax_unit_id,
1436: pepd.time_definition_id,
1437: pee.source_run_type,
1438: pee.assignment_id
1439: FROM pay_element_entries_f pee,
1440: pay_input_values_f piv,
1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,

Line 1541: FROM pay_element_entries_f pee,

1537: pepd.tax_unit_id,
1538: pepd.time_definition_id,
1539: pee.source_run_type,
1540: pee.assignment_id
1541: FROM pay_element_entries_f pee,
1542: pay_input_values_f piv,
1543: pay_element_entry_values_f peev,
1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,