APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 397: l_creator_type pay_element_entries_f.creator_type%type;

393: p_date in date)
394: return number
395: is
396: --
397: l_creator_type pay_element_entries_f.creator_type%type;
398: --
399: begin
400: --
401: select creator_type

Line 403: from pay_element_entries_f

399: begin
400: --
401: select creator_type
402: into l_creator_type
403: from pay_element_entries_f
404: where element_entry_id = p_element_entry_id
405: and p_date between effective_start_date
406: and effective_end_date;
407: --

Line 640: from pay_element_entries_f pee

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

Line 664: from pay_element_entries_f pee

660: and paa_mret.object_type = paa_ret.object_type
661: and paa_mret.payroll_action_id = paa_ret.payroll_action_id
662: and paa_mret.source_action_id is null
663: and exists (select ''
664: from pay_element_entries_f pee
665: where pee.creator_id = paa_mret.assignment_action_id
666: and pee.creator_type in ('RR', 'EE', 'NR', 'PR')
667: and pee.assignment_id = paa_ret.assignment_id);
668: --

Line 815: pay_element_entries_f pee1

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
819: (select 'Y'

Line 821: pay_element_entries_f pee2

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
825: and pepd1.run_result_id = pepd2.run_result_id

Line 1470: FROM pay_element_entries_f pee,

1466: pepd.tax_unit_id,
1467: pepd.time_definition_id,
1468: pee.source_run_type,
1469: pee.assignment_id
1470: FROM pay_element_entries_f pee,
1471: pay_input_values_f piv,
1472: pay_element_entry_values_f peev,
1473: pay_element_types_f pet,
1474: pay_element_types_f pet1,

Line 1574: FROM pay_element_entries_f pee,

1570: pepd.tax_unit_id,
1571: pepd.time_definition_id,
1572: pee.source_run_type,
1573: pee.assignment_id
1574: FROM pay_element_entries_f pee,
1575: pay_input_values_f piv,
1576: pay_element_entry_values_f peev,
1577: pay_element_types_f pet,
1578: pay_element_types_f pet1,