APPS.PAY_RETRO_PKG dependencies on PAY_ENTRY_PROCESS_DETAILS

Line 718: from pay_entry_process_details pepd1,

714: begin
715: --
716: select count(*)
717: into l_ovl_exists
718: from pay_entry_process_details pepd1,
719: pay_entry_process_details pepd2
720: where pepd1.element_entry_id = p_element_entry_id
721: and pepd2.element_entry_id > pepd1.element_entry_id
722: and pepd1.run_result_id = pepd2.run_result_id

Line 719: pay_entry_process_details pepd2

715: --
716: select count(*)
717: into l_ovl_exists
718: from pay_entry_process_details pepd1,
719: pay_entry_process_details pepd2
720: where pepd1.element_entry_id = p_element_entry_id
721: and pepd2.element_entry_id > pepd1.element_entry_id
722: and pepd1.run_result_id = pepd2.run_result_id
723: and pepd1.source_entry_id = pepd2.source_entry_id

Line 763: from pay_entry_process_details pepd1,

759: begin
760: --
761: select count(*)
762: into l_ovl_exists
763: from pay_entry_process_details pepd1,
764: pay_entry_process_details pepd2
765: where pepd1.element_entry_id = p_element_entry_id
766: and pepd2.element_entry_id > pepd1.element_entry_id
767: and pepd1.run_result_id = pepd2.run_result_id

Line 764: pay_entry_process_details pepd2

760: --
761: select count(*)
762: into l_ovl_exists
763: from pay_entry_process_details pepd1,
764: pay_entry_process_details pepd2
765: where pepd1.element_entry_id = p_element_entry_id
766: and pepd2.element_entry_id > pepd1.element_entry_id
767: and pepd1.run_result_id = pepd2.run_result_id
768: and pepd1.source_entry_id = pepd2.source_entry_id

Line 783: from pay_entry_process_details pepd1,

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

Line 789: from pay_entry_process_details pepd2,

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

Line 1445: pay_entry_process_details pepd,

1441: pay_element_entry_values_f peev,
1442: pay_element_types_f pet,
1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,
1447: pay_retro_defn_components prdc2,
1448: pay_retro_defn_components prdc
1449: WHERE pet1.element_type_id = pepd.source_element_type_id

Line 1548: pay_entry_process_details pepd,

1544: pay_element_types_f pet,
1545: pay_element_types_f pet1,
1546: pay_input_values_f piv1,
1547: pay_run_results prr,
1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,
1551: pay_retro_components prc,
1552: pay_retro_defn_components prdc2,