DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 2084: , pay_payroll_actions ppa

2080: /* Get Date_Earned of the payroll action */
2081: CURSOR get_date_earned(cp_assignment_action_id NUMBER) IS
2082: SELECT NVL(ppa.date_earned,ppa.effective_date)
2083: FROM pay_assignment_actions paa
2084: , pay_payroll_actions ppa
2085: WHERE paa.assignment_action_id = cp_assignment_action_id
2086: AND paa.payroll_action_id = ppa.payroll_action_id;
2087:
2088:

Line 2512: pay_payroll_actions ppa,

2508: ),
2509: pain.action_information7
2510: FROM pay_action_interlocks pai,
2511: pay_assignment_actions paa,
2512: pay_payroll_actions ppa,
2513: pay_action_interlocks pai1,
2514: pay_action_information pain
2515: WHERE pai.locking_action_id = cp_assignment_action_id
2516: AND pai.locked_action_id = pai1.locked_action_id