APPS.PAY_GET_TAX_EXISTS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1279: from pay_payroll_actions

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

Line 1459: from pay_payroll_actions

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

Line 2468: FROM pay_payroll_actions

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

Line 2604: pay_payroll_actions ppa

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

Line 2711: FROM pay_payroll_actions

2707: hr_utility.trace('l_wa_date = ' || to_char(l_wa_date, 'dd-mon-yyyy') );
2708:
2709: SELECT effective_date
2710: INTO l_effective_date
2711: FROM pay_payroll_actions
2712: WHERE payroll_action_id = p_pact_id;
2713:
2714: hr_utility.trace('l_effective_date = ' || to_char(l_effective_date,
2715: 'dd-mon-yyyy') );