APPS.PAY_US_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 2144: , pay_payroll_actions ppa

2140: /* Get Date_Earned of the payroll action */
2141: CURSOR get_date_earned(cp_assignment_action_id NUMBER) IS
2142: SELECT NVL(ppa.date_earned,ppa.effective_date)
2143: FROM pay_assignment_actions paa
2144: , pay_payroll_actions ppa
2145: WHERE paa.assignment_action_id = cp_assignment_action_id
2146: AND paa.payroll_action_id = ppa.payroll_action_id;
2147:
2148:

Line 2574: pay_payroll_actions ppa,

2570: ),
2571: pain.action_information7
2572: FROM pay_action_interlocks pai,
2573: pay_assignment_actions paa,
2574: pay_payroll_actions ppa,
2575: pay_action_interlocks pai1,
2576: pay_action_information pain
2577: WHERE pai.locking_action_id = cp_assignment_action_id
2578: AND pai.locked_action_id = pai1.locked_action_id

Line 2596: pay_payroll_actions ppa

2592: pai.effective_date,
2593: ppa.payroll_action_id
2594: from
2595: pay_action_information pai,
2596: pay_payroll_actions ppa
2597: where pai.action_context_id=cp_assignment_action_id
2598: AND ppa.payroll_action_id= (select payroll_action_id
2599: from pay_assignment_actions
2600: where assignment_action_id = cp_assignment_action_id)

Line 2617: pay_payroll_actions ppa

2613: action_information12,
2614: action_information13
2615: FROM
2616: pay_action_information pai,
2617: pay_payroll_actions ppa
2618: WHERE action_context_type = 'PA'
2619: AND action_context_id=ppa.payroll_action_id
2620: AND action_information_category = 'ADDRESS DETAILS'
2621: AND action_information14 = 'Employer Address'