DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PAY_PAYROLL_ACTIONS

Line 640: FROM pay_payroll_actions pac,

636: INTO l_action_chk
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

Line 694: FROM pay_payroll_actions pac,

690: INTO l_action_chk
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

Line 713: FROM pay_payroll_actions pac,

709: INTO l_action_chk
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

Line 1864: FROM pay_payroll_actions ppa

1860: -- 115.59 (START)
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