APPS.PAY_RETRO_PKG dependencies on PAY_ENTRY_PROCESS_DETAILS

Line 749: from pay_entry_process_details pepd1,

745: begin
746: --
747: select count(*)
748: into l_ovl_exists
749: from pay_entry_process_details pepd1,
750: pay_entry_process_details pepd2
751: where pepd1.element_entry_id = p_element_entry_id
752: and pepd2.element_entry_id > pepd1.element_entry_id
753: and pepd1.run_result_id = pepd2.run_result_id

Line 750: pay_entry_process_details pepd2

746: --
747: select count(*)
748: into l_ovl_exists
749: from pay_entry_process_details pepd1,
750: pay_entry_process_details pepd2
751: where pepd1.element_entry_id = p_element_entry_id
752: and pepd2.element_entry_id > pepd1.element_entry_id
753: and pepd1.run_result_id = pepd2.run_result_id
754: and pepd1.source_entry_id = pepd2.source_entry_id

Line 794: from pay_entry_process_details pepd1,

790: begin
791: --
792: select count(*)
793: into l_ovl_exists
794: from pay_entry_process_details pepd1,
795: pay_entry_process_details pepd2
796: where pepd1.element_entry_id = p_element_entry_id
797: and pepd2.element_entry_id > pepd1.element_entry_id
798: and pepd1.run_result_id = pepd2.run_result_id

Line 795: pay_entry_process_details pepd2

791: --
792: select count(*)
793: into l_ovl_exists
794: from pay_entry_process_details pepd1,
795: pay_entry_process_details pepd2
796: where pepd1.element_entry_id = p_element_entry_id
797: and pepd2.element_entry_id > pepd1.element_entry_id
798: and pepd1.run_result_id = pepd2.run_result_id
799: and pepd1.source_entry_id = pepd2.source_entry_id

Line 814: from pay_entry_process_details pepd1,

810: --
811: if (l_ovl_exists = 0) then
812: select count(*)
813: into l_matching_pr
814: from pay_entry_process_details pepd1,
815: pay_element_entries_f pee1
816: where pepd1.element_entry_id = p_element_entry_id
817: and pepd1.element_entry_id = pee1.element_entry_id
818: and exists

Line 820: from pay_entry_process_details pepd2,

816: where pepd1.element_entry_id = p_element_entry_id
817: and pepd1.element_entry_id = pee1.element_entry_id
818: and exists
819: (select 'Y'
820: from pay_entry_process_details pepd2,
821: pay_element_entries_f pee2
822: where pee2.creator_type = 'PR'
823: and pee2.element_entry_id = pepd2.element_entry_id
824: and pee2.assignment_id = pee1.assignment_id

Line 1476: pay_entry_process_details pepd,

1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,
1478: pay_retro_defn_components prdc2,
1479: pay_retro_defn_components prdc
1480: WHERE pet1.element_type_id = pepd.source_element_type_id

Line 1581: pay_entry_process_details pepd,

1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,
1579: pay_input_values_f piv1,
1580: pay_run_results prr,
1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,
1584: pay_retro_components prc,
1585: pay_retro_defn_components prdc2,