APPS.HREMPTER dependencies on PAY_ASSIGNMENT_ACTIONS

Line 629: pay_assignment_actions act,

625: FROM sys.dual
626: WHERE exists
627: (SELECT null
628: FROM pay_payroll_actions pac,
629: pay_assignment_actions act,
630: per_assignments_f asg
631: WHERE asg.person_id = p_person_id
632: AND act.assignment_id = asg.assignment_id
633: AND pac.payroll_action_id = act.payroll_action_id

Line 683: pay_assignment_actions act,

679: FROM sys.dual
680: WHERE exists
681: (SELECT null
682: FROM pay_payroll_actions pac,
683: pay_assignment_actions act,
684: per_assignments_f asg
685: WHERE asg.person_id = p_person_id
686: AND act.assignment_id = asg.assignment_id
687: AND pac.payroll_action_id = act.payroll_action_id

Line 702: pay_assignment_actions act,

698: FROM sys.dual
699: WHERE exists
700: (SELECT null
701: FROM pay_payroll_actions pac,
702: pay_assignment_actions act,
703: per_assignments_f asg
704: WHERE asg.person_id = p_person_id
705: AND act.assignment_id = asg.assignment_id
706: AND pac.payroll_action_id = act.payroll_action_id

Line 1847: ,pay_assignment_actions paa

1843: --
1844: CURSOR csr_alu_actions IS
1845: SELECT NULL
1846: FROM pay_payroll_actions ppa
1847: ,pay_assignment_actions paa
1848: WHERE ppa.payroll_action_id = paa.payroll_action_id
1849: AND ppa.action_type IN ('R','Q','V','B')
1850: AND paa.assignment_id = p_assignment_id
1851: AND NVL(ppa.date_earned,ppa.effective_date) > p_term_date;