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.PAY_AU_TERMINATIONS dependencies on PAY_PAYROLL_ACTIONS

Line 628: , pay_payroll_actions PAY_ACTION

624: where result.source_id = l_source_id --Bug 3306112
625: and result.status <> 'U'
626: and exists ( select 1
627: from pay_assignment_actions ASGT_ACTION
628: , pay_payroll_actions PAY_ACTION
629: , per_time_periods PERIOD
630: where result.assignment_action_id = asgt_action.assignment_action_id
631: and asgt_action.payroll_action_id = pay_action.payroll_action_id
632: and pay_action.payroll_id = period.payroll_id

Line 1412: ,pay_payroll_actions ppa

1408: c_fin_end_date in date)
1409: IS
1410: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id
1411: FROM pay_assignment_actions paa
1412: ,pay_payroll_actions ppa
1413: WHERE paa.assignment_id = c_assignment_id
1414: and ppa.payroll_action_id = paa.payroll_action_id
1415: and ppa.business_group_id = c_business_group_id
1416: AND paa.action_sequence in

Line 1420: pay_payroll_actions ppa,

1416: AND paa.action_sequence in
1417: (
1418: SELECT MAX(paa.action_sequence)
1419: FROM pay_assignment_actions paa,
1420: pay_payroll_actions ppa,
1421: per_all_assignments_f paaf
1422: WHERE ppa.business_group_id = c_business_group_id
1423: AND paaf.assignment_id = c_assignment_id
1424: AND paa.assignment_id = paaf.assignment_id

Line 1442: ,pay_payroll_actions ppa

1438: c_fin_end_date in date)
1439: IS
1440: SELECT paa.assignment_action_id, paa.tax_unit_id, ppa.payroll_id, ppa.effective_date
1441: FROM pay_assignment_actions paa
1442: ,pay_payroll_actions ppa
1443: WHERE paa.assignment_id = c_assignment_id
1444: and ppa.payroll_action_id = paa.payroll_action_id
1445: and ppa.business_group_id = c_business_group_id
1446: AND paa.action_sequence in

Line 1450: pay_payroll_actions ppa,

1446: AND paa.action_sequence in
1447: (
1448: SELECT MAX(paa.action_sequence)
1449: FROM pay_assignment_actions paa,
1450: pay_payroll_actions ppa,
1451: per_all_assignments_f paaf
1452: WHERE ppa.business_group_id = c_business_group_id
1453: AND paaf.assignment_id = c_assignment_id
1454: AND paa.assignment_id = paaf.assignment_id

Line 1502: FROM pay_payroll_actions ppa,

1498:
1499: CURSOR c_get_payroll_effective_date
1500: IS
1501: SELECT ppa.effective_date
1502: FROM pay_payroll_actions ppa,
1503: pay_assignment_actions paa
1504: WHERE paa.assignment_action_id = p_assignment_action_id
1505: AND ppa.payroll_action_id = paa.payroll_action_id;
1506:

Line 1514: pay_payroll_actions ppa,

1510: c_end_date in date)
1511: IS
1512: SELECT count(paa.assignment_action_id)
1513: FROM pay_assignment_actions paa,
1514: pay_payroll_actions ppa,
1515: per_assignments_f paf
1516: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
1517: AND ppa.business_group_id = c_business_group_id
1518: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2241: pay_payroll_actions ppa,

2237: cursor c_max_asg_action_id (c_year_start date
2238: ,c_year_end date) is
2239: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2240: from pay_assignment_actions paa,
2241: pay_payroll_actions ppa,
2242: per_assignments_f paf
2243: where paa.assignment_id = paf.assignment_id
2244: and paf.assignment_id = p_assignment_id
2245: and ppa.payroll_action_id = paa.payroll_action_id

Line 2594: pay_payroll_actions ppa,

2590: cursor c_max_asg_action_id (c_year_start date
2591: ,c_year_end date) is
2592: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2593: from pay_assignment_actions paa,
2594: pay_payroll_actions ppa,
2595: per_assignments_f paf
2596: where paa.assignment_id = paf.assignment_id
2597: and paf.assignment_id = p_assignment_id
2598: and ppa.payroll_action_id = paa.payroll_action_id

Line 3230: pay_payroll_actions ppa,

3226: from
3227: per_time_periods ptp,
3228: per_all_assignments_f paa,
3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,

Line 3399: pay_payroll_actions ppa,

3395: cursor c_max_asg_action_id (c_year_start date
3396: ,c_year_end date) is
3397: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3398: from pay_assignment_actions paa,
3399: pay_payroll_actions ppa,
3400: per_assignments_f paf
3401: where paa.assignment_id = paf.assignment_id
3402: and paf.assignment_id = p_assignment_id
3403: and ppa.payroll_action_id = paa.payroll_action_id

Line 3724: pay_payroll_actions ppa,

3720: ,c_year_end date
3721: ,c_assignment_id number) is
3722: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3723: from pay_assignment_actions paa,
3724: pay_payroll_actions ppa,
3725: per_assignments_f paf
3726: where paa.assignment_id = paf.assignment_id
3727: and paf.assignment_id = c_assignment_id
3728: and ppa.payroll_action_id = paa.payroll_action_id

Line 3791: pay_payroll_actions ppa,

3787: ,c_year_end date
3788: ,c_assignment_id number) is
3789: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3790: from pay_assignment_actions paa,
3791: pay_payroll_actions ppa,
3792: per_assignments_f paf
3793: where paa.assignment_id = paf.assignment_id
3794: and paf.assignment_id = c_assignment_id
3795: and ppa.payroll_action_id = paa.payroll_action_id