DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PAY_PAYROLL_ACTIONS

Line 628: FROM pay_payroll_actions pac,

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

Line 682: FROM pay_payroll_actions pac,

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

Line 701: FROM pay_payroll_actions pac,

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

Line 1846: FROM pay_payroll_actions ppa

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