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 PER_ASSIGNMENTS_F

Line 1483: per_assignments_f paf,

1479: is
1480: select count(DISTINCT ptp.time_period_id)
1481: from per_time_periods ptp
1482: where exists (select 'EXISTS' from
1483: per_assignments_f paf,
1484: hr_soft_coding_keyflex hsck
1485: where paf.assignment_id = p_assignment_id
1486: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
1487: and hsck.segment1 = c_tax_unit_id

Line 1515: per_assignments_f paf

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
1519: AND paa.assignment_id = c_assignment_id

Line 2242: per_assignments_f paf

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
2246: and ppa.effective_date between c_year_start and c_year_end

Line 2595: per_assignments_f paf

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
2599: and ppa.effective_date between c_year_start and c_year_end

Line 3400: per_assignments_f paf

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
3404: and ppa.effective_date between c_year_start and c_year_end

Line 3725: per_assignments_f paf

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
3729: and ppa.effective_date between c_year_start and c_year_end

Line 3792: per_assignments_f paf

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
3796: and ppa.effective_date between c_year_start and c_year_end