APPS.HRENTMNT dependencies on PAY_PAYROLL_ACTIONS

Line 788: pay_payroll_actions ppa

784: where pqi.element_entry_id = p_element_entry_id
785: and exists
786: (select null
787: from pay_assignment_actions paa,
788: pay_payroll_actions ppa
789: where paa.assignment_action_id = pqi.assignment_action_id
790: and ppa.payroll_action_id = paa.payroll_action_id
791: and ppa.date_earned between p_validation_start_date
792: and p_validation_end_date);

Line 824: pay_payroll_actions ppa

820: where pqe.element_entry_id = p_element_entry_id
821: and exists
822: (select null
823: from pay_assignment_actions paa,
824: pay_payroll_actions ppa
825: where paa.assignment_action_id = pqe.assignment_action_id
826: and ppa.payroll_action_id = paa.payroll_action_id
827: and ppa.date_earned between p_validation_start_date
828: and p_validation_end_date);

Line 859: pay_payroll_actions pa

855: --
856: cursor csr_del_or_zap is
857: select pa.effective_date
858: from pay_assignment_actions aa,
859: pay_payroll_actions pa
860: where aa.assignment_id = p_assignment_id
861: and pa.action_type not in ('X', 'BEE')
862: and pa.payroll_action_id = aa.payroll_action_id
863: and ((pa.effective_date >= p_validation_start_date)

Line 870: pay_payroll_actions pa

866: --
867: cursor csr_not_insert is
868: select pa.effective_date
869: from pay_assignment_actions aa,
870: pay_payroll_actions pa
871: where aa.assignment_id = p_assignment_id
872: and pa.payroll_action_id = aa.payroll_action_id
873: and pa.action_type not in ('X', 'BEE')
874: and ((pa.effective_date between p_validation_start_date

Line 988: -- pay_payroll_actions pa

984: -- from sys.dual
985: -- where exists
986: -- (select null
987: -- from pay_assignment_actions aa,
988: -- pay_payroll_actions pa
989: -- where aa.assignment_id = p_assignment_id
990: -- and pa.action_type not in ('X', 'BEE')
991: -- and pa.payroll_action_id = aa.payroll_action_id
992: -- and ((pa.effective_date >= p_validation_start_date)

Line 1027: -- pay_payroll_actions pa

1023: -- from sys.dual
1024: -- where exists
1025: -- (select null
1026: -- from pay_assignment_actions aa,
1027: -- pay_payroll_actions pa
1028: -- where aa.assignment_id = p_assignment_id
1029: -- and pa.payroll_action_id = aa.payroll_action_id
1030: -- and pa.action_type not in ('X', 'BEE')
1031: -- and ((pa.effective_date between p_validation_start_date