APPS.HREMPTER dependencies on PAY_ASSIGNMENT_ACTIONS

Line 641: pay_assignment_actions act,

637: FROM sys.dual
638: WHERE exists
639: (SELECT null
640: FROM pay_payroll_actions pac,
641: pay_assignment_actions act,
642: per_assignments_f asg
643: WHERE asg.person_id = p_person_id
644: AND act.assignment_id = asg.assignment_id
645: AND pac.payroll_action_id = act.payroll_action_id

Line 695: pay_assignment_actions act,

691: FROM sys.dual
692: WHERE exists
693: (SELECT null
694: FROM pay_payroll_actions pac,
695: pay_assignment_actions act,
696: per_assignments_f asg
697: WHERE asg.person_id = p_person_id
698: AND act.assignment_id = asg.assignment_id
699: AND pac.payroll_action_id = act.payroll_action_id

Line 714: pay_assignment_actions act,

710: FROM sys.dual
711: WHERE exists
712: (SELECT null
713: FROM pay_payroll_actions pac,
714: pay_assignment_actions act,
715: per_assignments_f asg
716: WHERE asg.person_id = p_person_id
717: AND act.assignment_id = asg.assignment_id
718: AND pac.payroll_action_id = act.payroll_action_id

Line 1865: ,pay_assignment_actions paa

1861: --
1862: CURSOR csr_alu_actions IS
1863: SELECT NULL
1864: FROM pay_payroll_actions ppa
1865: ,pay_assignment_actions paa
1866: WHERE ppa.payroll_action_id = paa.payroll_action_id
1867: AND ppa.action_type IN ('R','Q','V','B')
1868: AND paa.assignment_id = p_assignment_id
1869: AND NVL(ppa.date_earned,ppa.effective_date) > p_term_date;