APPS.HR_US_FF_UDF1 dependencies on PAY_PAYROLL_ACTIONS

Line 334: pay_payroll_actions ppa

330:
331: FROM per_addresses pad,
332: per_assignments_f paf,
333: pay_assignment_actions paa,
334: pay_payroll_actions ppa
335:
336: WHERE pad.primary_flag = 'Y'
337: AND pad.person_id = paf.person_id
338: AND ppa.date_earned BETWEEN pad.date_from

Line 435: pay_payroll_actions ppa1

431: ppa1.payroll_id
432: INTO l_bal_assact,
433: l_payroll_id
434: FROM pay_assignment_Actions paa1,
435: pay_payroll_actions ppa1
436: WHERE paa1.assignment_id = l_assignment_id
437: AND paa1.tax_unit_id = p_tax_unit_id
438: AND paa1.action_sequence =
439: (SELECT max(paa_prev.action_sequence)

Line 441: , pay_payroll_actions ppa

437: AND paa1.tax_unit_id = p_tax_unit_id
438: AND paa1.action_sequence =
439: (SELECT max(paa_prev.action_sequence)
440: FROM per_time_periods ptp
441: , pay_payroll_actions ppa
442: , pay_assignment_actions paa
443: , per_time_periods ptp_prev
444: , pay_payroll_actions ppa_prev
445: , pay_assignment_actions paa_prev

Line 444: , pay_payroll_actions ppa_prev

440: FROM per_time_periods ptp
441: , pay_payroll_actions ppa
442: , pay_assignment_actions paa
443: , per_time_periods ptp_prev
444: , pay_payroll_actions ppa_prev
445: , pay_assignment_actions paa_prev
446: WHERE paa.assignment_action_id = p_assignment_action_id
447: AND ppa.payroll_action_id = paa.payroll_action_id
448: -- AND ptp.time_period_id = ppa.time_period_id

Line 1389: pay_payroll_actions ppa

1385: CURSOR csr_use_it_flag (p_assignment_action_id IN NUMBER) IS
1386: SELECT NVL(fed.fed_information1,'N'),paa.assignment_id
1387: FROM pay_us_emp_fed_tax_rules_f fed,
1388: pay_assignment_actions paa,
1389: pay_payroll_actions ppa
1390: WHERE paa.assignment_id = fed.assignment_id
1391: AND paa.assignment_action_id = p_assignment_action_id
1392: AND paa.payroll_action_id = ppa.payroll_action_id
1393: AND NVL(ppa.date_earned,ppa.effective_date)

Line 1398: l_time_period_id pay_payroll_actions.time_period_id%TYPE;

1394: BETWEEN fed.effective_start_date AND fed.effective_end_date;
1395:
1396: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;
1397: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1398: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
1399: l_return_flag VARCHAR2(2);
1400: l_business_group_id NUMBER;
1401: l_tax_unit_id NUMBER;
1402:

Line 1424: pay_payroll_actions ppa

1420: l_payroll_id,
1421: l_business_group_id,
1422: l_tax_unit_id
1423: FROM pay_assignment_actions paa,
1424: pay_payroll_actions ppa
1425: WHERE paa.assignment_action_id = p_assignment_action_id
1426: AND ppa.payroll_action_id = paa.payroll_action_id;
1427:
1428: hr_utility.trace('Assignment_Action_Id :'||to_char(p_assignment_action_id));

Line 2460: pay_payroll_actions ppa

2456: SELECT NVL(prl_information12 ,'P') --Defaulted to Previous
2457: ,NVL(prl_information13 ,'YTD') --defaulted to Tax Year
2458: FROM pay_payrolls_f payroll,
2459: pay_assignment_actions paa,
2460: pay_payroll_actions ppa
2461: WHERE ppa.payroll_id = payroll.payroll_id
2462: AND paa.payroll_action_id = ppa.payroll_action_id
2463: AND paa.assignment_action_id = p_assignment_action_id
2464: AND NVL(ppa.date_earned,ppa.effective_date)

Line 2534: l_time_period_id pay_payroll_actions.time_period_id%TYPE;

2530: l_remaining_hours NUMBER;
2531: l_jd_hours NUMBER;
2532: l_end_date DATE;
2533: l_start_date DATE;
2534: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
2535: l_counter INTEGER;
2536: l_tg_jurisdiction_code VARCHAR2(20);
2537: l_tg_sum_hours NUMBER;
2538: l_tg_total_hours NUMBER;

Line 5246: --p_effective_date - pay_payroll_actions.effective_date;

5242: hr_utility.trace('EMJT: Jurisdiction Level -> '||p_jd_level);
5243: hr_utility.trace('EMJT: Payroll Effective Date -> '||to_char(p_effective_date,'DD-MON-YYYY'));
5244: hr_utility.trace('EMJT: Payroll Period End Date -> '||to_char(p_end_date,'DD-MON-YYYY'));
5245:
5246: --p_effective_date - pay_payroll_actions.effective_date;
5247: --p_date_earned - pay_payroll_actions.date_earned;
5248:
5249: IF p_threshold_basis = 'YTD' THEN
5250: l_start_date := TRUNC(p_effective_date,'Y');

Line 5247: --p_date_earned - pay_payroll_actions.date_earned;

5243: hr_utility.trace('EMJT: Payroll Effective Date -> '||to_char(p_effective_date,'DD-MON-YYYY'));
5244: hr_utility.trace('EMJT: Payroll Period End Date -> '||to_char(p_end_date,'DD-MON-YYYY'));
5245:
5246: --p_effective_date - pay_payroll_actions.effective_date;
5247: --p_date_earned - pay_payroll_actions.date_earned;
5248:
5249: IF p_threshold_basis = 'YTD' THEN
5250: l_start_date := TRUNC(p_effective_date,'Y');
5251: l_end_date := p_effective_date;

Line 5391: from pay_payroll_actions

5387:
5388: cursor csr_get_dates is
5389: select effective_date,
5390: date_earned
5391: from pay_payroll_actions
5392: where payroll_action_id = p_payroll_action_id;
5393:
5394: begin
5395: