APPS.PAY_KR_WG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 154: from pay_payroll_actions PACTION

150: IS
151: select TPERIOD.start_date
152: ,TPERIOD.end_date
153: ,PACTION.payroll_action_id
154: from pay_payroll_actions PACTION
155: ,pay_assignment_actions ASSACTION
156: ,per_time_periods TPERIOD
157: ,per_time_period_types TPTYPE
158: where ASSACTION.assignment_action_id = p_asg_action_id

Line 336: from pay_payroll_actions ppa

332: -- to get the element_type_id of 'WG Results'
333: --
334: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
335: SELECT fnd_date.canonical_to_date(prrv.result_value)
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv
340: ,pay_run_result_values prrv1

Line 1943: -- Bug 2762097 Fetch payoutdate from legislative_parameters in pay_payroll_actions table

1939: OPEN csr_pay_period(p_assignment_action_id);
1940: FETCH csr_pay_period INTO l_period_start_date, l_period_end_date, l_payroll_action_id;
1941: CLOSE csr_pay_period;
1942:
1943: -- Bug 2762097 Fetch payoutdate from legislative_parameters in pay_payroll_actions table
1944: -- Bug 3021794 payout date is now stored in canonical format in legislative parameter.
1945: -- Thus modified the function call to get_legislative_parameter
1946:
1947: l_payout_date := fnd_date.canonical_to_date (pay_kr_ff_functions_pkg.get_legislative_parameter(