APPS.HRENTMNT dependencies on PAY_PAYROLL_ACTIONS

Line 628: pay_payroll_actions ppa

624: where pqi.element_entry_id = p_element_entry_id
625: and exists
626: (select null
627: from pay_assignment_actions paa,
628: pay_payroll_actions ppa
629: where paa.assignment_action_id = pqi.assignment_action_id
630: and ppa.payroll_action_id = paa.payroll_action_id
631: and ppa.date_earned between p_validation_start_date
632: and p_validation_end_date);

Line 664: pay_payroll_actions ppa

660: where pqe.element_entry_id = p_element_entry_id
661: and exists
662: (select null
663: from pay_assignment_actions paa,
664: pay_payroll_actions ppa
665: where paa.assignment_action_id = pqe.assignment_action_id
666: and ppa.payroll_action_id = paa.payroll_action_id
667: and ppa.date_earned between p_validation_start_date
668: and p_validation_end_date);

Line 699: pay_payroll_actions pa

695: --
696: cursor csr_del_or_zap is
697: select pa.effective_date
698: from pay_assignment_actions aa,
699: pay_payroll_actions pa
700: where aa.assignment_id = p_assignment_id
701: and pa.action_type not in ('X', 'BEE')
702: and pa.payroll_action_id = aa.payroll_action_id
703: and ((pa.effective_date >= p_validation_start_date)

Line 710: pay_payroll_actions pa

706: --
707: cursor csr_not_insert(l_validation_start_date date) is
708: select pa.effective_date
709: from pay_assignment_actions aa,
710: pay_payroll_actions pa
711: where aa.assignment_id = p_assignment_id
712: and pa.payroll_action_id = aa.payroll_action_id
713: and pa.action_type not in ('X', 'BEE')
714: and ((pa.effective_date between l_validation_start_date

Line 836: -- pay_payroll_actions pa

832: -- from sys.dual
833: -- where exists
834: -- (select null
835: -- from pay_assignment_actions aa,
836: -- pay_payroll_actions pa
837: -- where aa.assignment_id = p_assignment_id
838: -- and pa.action_type not in ('X', 'BEE')
839: -- and pa.payroll_action_id = aa.payroll_action_id
840: -- and ((pa.effective_date >= p_validation_start_date)

Line 887: -- pay_payroll_actions pa

883: -- from sys.dual
884: -- where exists
885: -- (select null
886: -- from pay_assignment_actions aa,
887: -- pay_payroll_actions pa
888: -- where aa.assignment_id = p_assignment_id
889: -- and pa.payroll_action_id = aa.payroll_action_id
890: -- and pa.action_type not in ('X', 'BEE')
891: -- and ((pa.effective_date between p_validation_start_date