APPS.HR_US_FF_UDF1 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 333: pay_assignment_actions paa,

329: )
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

Line 405: FROM pay_assignment_actions paa

401: to_char(p_regular_aggregate) );
402:
403: SELECT paa.assignment_id
404: INTO l_assignment_id
405: FROM pay_assignment_actions paa
406: where paa.assignment_action_id = p_assignment_action_id;
407:
408:
409: /* commented for bug 7238809 .As fetching home jurisdiction using

Line 434: FROM pay_assignment_Actions paa1,

430: SELECT /*+ RULE */ paa1.assignment_action_id,
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 =

Line 442: , pay_assignment_actions paa

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
446: WHERE paa.assignment_action_id = p_assignment_action_id

Line 445: , pay_assignment_actions paa_prev

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
449: AND ppa.effective_date between ptp.start_date /*Bug:3909937*/

Line 1353: select /*+ INDEX (paa pay_assignment_actions_n51) */ distinct

1349: and piv2.effective_end_date
1350: and piv2.name = 'Percentage';
1351:
1352: Cursor tagged_earnings_Cursor is
1353: select /*+ INDEX (paa pay_assignment_actions_n51) */ distinct
1354: peev.element_entry_id,
1355: peev.screen_entry_value
1356: from pay_element_classifications pec
1357: ,pay_element_types_f pet

Line 1388: pay_assignment_actions paa,

1384: -- Get flag to determine assignment has only IT time.
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

Line 1423: FROM pay_assignment_actions paa,

1419: l_time_period_id,
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:

Line 2459: pay_assignment_actions paa,

2455: CURSOR csr_period_flag (p_assignment_action_id IN NUMBER) IS
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

Line 2644: SELECT /*+ INDEX (paa pay_assignment_actions_n51) */ DISTINCT

2640: p_end_date IN DATE,
2641: p_assignment_id IN NUMBER,
2642: p_date_earned IN DATE)
2643: IS
2644: SELECT /*+ INDEX (paa pay_assignment_actions_n51) */ DISTINCT
2645: peev.screen_entry_value Jurisdiction,
2646: 0 Hours
2647: FROM pay_element_classifications pec
2648: ,pay_element_types_f pet