eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_FF_UDF1 dependencies on PAY_PAYROLL_ACTIONS

Line 375: pay_payroll_actions ppa

371:
372: FROM per_addresses pad,
373: per_assignments_f paf,
374: pay_assignment_actions paa,
375: pay_payroll_actions ppa
376:
377: WHERE pad.primary_flag = 'Y'
378: AND pad.person_id = paf.person_id
379: AND ppa.date_earned BETWEEN pad.date_from

Line 476: pay_payroll_actions ppa1

472: ppa1.payroll_id
473: INTO l_bal_assact,
474: l_payroll_id
475: FROM pay_assignment_Actions paa1,
476: pay_payroll_actions ppa1
477: WHERE paa1.assignment_id = l_assignment_id
478: AND paa1.tax_unit_id = p_tax_unit_id
479: AND paa1.action_sequence =
480: (SELECT max(paa_prev.action_sequence)

Line 482: , pay_payroll_actions ppa

478: AND paa1.tax_unit_id = p_tax_unit_id
479: AND paa1.action_sequence =
480: (SELECT max(paa_prev.action_sequence)
481: FROM per_time_periods ptp
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev
486: , pay_assignment_actions paa_prev

Line 485: , pay_payroll_actions ppa_prev

481: FROM per_time_periods ptp
482: , pay_payroll_actions ppa
483: , pay_assignment_actions paa
484: , per_time_periods ptp_prev
485: , pay_payroll_actions ppa_prev
486: , pay_assignment_actions paa_prev
487: WHERE paa.assignment_action_id = p_assignment_action_id
488: AND ppa.payroll_action_id = paa.payroll_action_id
489: -- AND ptp.time_period_id = ppa.time_period_id

Line 1430: pay_payroll_actions ppa

1426: CURSOR csr_use_it_flag (p_assignment_action_id IN NUMBER) IS
1427: SELECT NVL(fed.fed_information1,'N'),paa.assignment_id
1428: FROM pay_us_emp_fed_tax_rules_f fed,
1429: pay_assignment_actions paa,
1430: pay_payroll_actions ppa
1431: WHERE paa.assignment_id = fed.assignment_id
1432: AND paa.assignment_action_id = p_assignment_action_id
1433: AND paa.payroll_action_id = ppa.payroll_action_id
1434: AND NVL(ppa.date_earned,ppa.effective_date)

Line 1439: l_time_period_id pay_payroll_actions.time_period_id%TYPE;

1435: BETWEEN fed.effective_start_date AND fed.effective_end_date;
1436:
1437: l_use_it_flag pay_us_emp_fed_tax_rules_f.fed_information1%TYPE;
1438: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1439: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
1440: l_return_flag VARCHAR2(2);
1441: l_business_group_id NUMBER;
1442: l_tax_unit_id NUMBER;
1443:

Line 1465: pay_payroll_actions ppa

1461: l_payroll_id,
1462: l_business_group_id,
1463: l_tax_unit_id
1464: FROM pay_assignment_actions paa,
1465: pay_payroll_actions ppa
1466: WHERE paa.assignment_action_id = p_assignment_action_id
1467: AND ppa.payroll_action_id = paa.payroll_action_id;
1468:
1469: hr_utility.trace('Assignment_Action_Id :'||to_char(p_assignment_action_id));

Line 2559: pay_payroll_actions ppa

2555: SELECT NVL(prl_information12 ,'P') --Defaulted to Previous
2556: ,NVL(prl_information13 ,'YTD') --defaulted to Tax Year
2557: FROM pay_payrolls_f payroll,
2558: pay_assignment_actions paa,
2559: pay_payroll_actions ppa
2560: WHERE ppa.payroll_id = payroll.payroll_id
2561: AND paa.payroll_action_id = ppa.payroll_action_id
2562: AND paa.assignment_action_id = p_assignment_action_id
2563: AND NVL(ppa.date_earned,ppa.effective_date)

Line 2633: l_time_period_id pay_payroll_actions.time_period_id%TYPE;

2629: l_remaining_hours NUMBER;
2630: l_jd_hours NUMBER;
2631: l_end_date DATE;
2632: l_start_date DATE;
2633: l_time_period_id pay_payroll_actions.time_period_id%TYPE;
2634: l_counter INTEGER;
2635: l_tg_jurisdiction_code VARCHAR2(20);
2636: l_tg_sum_hours NUMBER;
2637: l_tg_total_hours NUMBER;

Line 5433: --p_effective_date - pay_payroll_actions.effective_date;

5429: hr_utility.trace('EMJT: Jurisdiction Level -> '||p_jd_level);
5430: hr_utility.trace('EMJT: Payroll Effective Date -> '||to_char(p_effective_date,'DD-MON-YYYY'));
5431: hr_utility.trace('EMJT: Payroll Period End Date -> '||to_char(p_end_date,'DD-MON-YYYY'));
5432:
5433: --p_effective_date - pay_payroll_actions.effective_date;
5434: --p_date_earned - pay_payroll_actions.date_earned;
5435:
5436: IF p_threshold_basis = 'YTD' THEN
5437: l_start_date := TRUNC(p_effective_date,'Y');

Line 5434: --p_date_earned - pay_payroll_actions.date_earned;

5430: hr_utility.trace('EMJT: Payroll Effective Date -> '||to_char(p_effective_date,'DD-MON-YYYY'));
5431: hr_utility.trace('EMJT: Payroll Period End Date -> '||to_char(p_end_date,'DD-MON-YYYY'));
5432:
5433: --p_effective_date - pay_payroll_actions.effective_date;
5434: --p_date_earned - pay_payroll_actions.date_earned;
5435:
5436: IF p_threshold_basis = 'YTD' THEN
5437: l_start_date := TRUNC(p_effective_date,'Y');
5438: l_end_date := p_effective_date;

Line 5578: from pay_payroll_actions

5574:
5575: cursor csr_get_dates is
5576: select effective_date,
5577: date_earned
5578: from pay_payroll_actions
5579: where payroll_action_id = p_payroll_action_id;
5580:
5581: begin
5582:

Line 5989: from pay_payroll_actions

5985:
5986: -- Get the Date Paid for the current run
5987: CURSOR csr_get_date_paid IS
5988: select effective_date
5989: from pay_payroll_actions
5990: where payroll_action_id = p_payroll_action_id;
5991:
5992: --To print the Warning message for an assignment whose possible Head Tax
5993: --might not be withheld due to Date Paid in different month than that of

Line 6210: FUNCTION count_remaining_pay_periods(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE, --Context

6206:
6207: /*Added for Bug#12583094*/
6208:
6209: --Function to give the number of pay periods left in the given year based on the p_logical_hire_date.
6210: FUNCTION count_remaining_pay_periods(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE, --Context
6211: p_logical_hire_date IN DATE ) --Parameter
6212: RETURN NUMBER IS
6213:
6214: CURSOR get_count IS

Line 6216: FROM pay_payroll_actions paction,

6212: RETURN NUMBER IS
6213:
6214: CURSOR get_count IS
6215: SELECT decode(count(regular_payment_date),0,1,count(regular_payment_date))
6216: FROM pay_payroll_actions paction,
6217: per_time_periods target
6218: WHERE paction.payroll_action_id = p_payroll_action_id
6219: AND target.payroll_id = paction.payroll_id
6220: AND to_char(target.regular_payment_date,'YYYY')=to_char(paction.effective_date,'YYYY')

Line 6521: ,pay_payroll_actions PACT

6517: ,pay_balance_feeds_f FEED
6518: ,pay_run_results RR
6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT
6521: ,pay_payroll_actions PACT
6522: ,pay_payroll_actions BACT
6523: ,per_all_assignments_f ASS
6524: WHERE BAL_ASSACT.assignment_action_id = p_asgmnt_action_id
6525: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 6522: ,pay_payroll_actions BACT

6518: ,pay_run_results RR
6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT
6521: ,pay_payroll_actions PACT
6522: ,pay_payroll_actions BACT
6523: ,per_all_assignments_f ASS
6524: WHERE BAL_ASSACT.assignment_action_id = p_asgmnt_action_id
6525: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
6526: AND FEED.balance_type_id = p_balance_type_id + decode(TARGET.INPUT_VALUE_ID, null, 0, 0)