APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1276: from pay_payroll_actions

1272: l_across_years = 'Y') then
1273:
1274: select to_char(effective_date,'dd-mm-yyyy')
1275: into l_date
1276: from pay_payroll_actions
1277: where payroll_action_id = p_pact_id;
1278:
1279: hr_utility.trace('l_date '||to_char(l_date));
1280: else

Line 1456: from pay_payroll_actions

1452: if (l_across_years = 'Y') then
1453:
1454: select to_char(effective_date,'dd-mm-yyyy')
1455: into l_date
1456: from pay_payroll_actions
1457: where payroll_action_id = p_pact_id;
1458:
1459: hr_utility.trace('l_date '||to_char(l_date));
1460: else

Line 2465: FROM pay_payroll_actions

2461: l_across_years = 'Y') THEN
2462:
2463: SELECT to_char(effective_date,'dd-mm-yyyy')
2464: INTO l_date
2465: FROM pay_payroll_actions
2466: WHERE payroll_action_id = p_pact_id;
2467:
2468: hr_utility.trace('l_date '||to_char(l_date));
2469: ELSE

Line 2601: pay_payroll_actions ppa

2597: l_date_paid date;
2598: CURSOR get_date_paid IS
2599: SELECT ppa.effective_date
2600: FROM
2601: pay_payroll_actions ppa
2602: WHERE ppa.payroll_action_id=p_pact_id;
2603: --Bug 7441418 ends
2604: BEGIN
2605: OPEN get_date_paid; --For bug 7441418