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_PERIODS_OF_SERVICE

Line 2232: from per_periods_of_service pps, per_all_assignments_f paaf

2228: group by peev.screen_entry_value;
2229:
2230: cursor csr_get_curr_atd is
2231: select pps.actual_termination_date
2232: from per_periods_of_service pps, per_all_assignments_f paaf
2233: where paaf.assignment_id = p_assignment_id
2234: and p_date_paid between paaf.effective_start_date and paaf.effective_end_date
2235: and paaf.period_of_service_id = pps.period_of_service_id ;
2236:

Line 2585: from per_periods_of_service pps, per_all_assignments_f paaf

2581:
2582:
2583: cursor csr_get_curr_atd is
2584: select pps.actual_termination_date
2585: from per_periods_of_service pps, per_all_assignments_f paaf
2586: where paaf.assignment_id = p_assignment_id
2587: and p_date_paid between paaf.effective_start_date and paaf.effective_end_date
2588: and paaf.period_of_service_id = pps.period_of_service_id ;
2589:

Line 3390: from per_periods_of_service pps, per_all_assignments_f paaf

3386: return number is
3387:
3388: cursor csr_get_curr_atd is
3389: select pps.actual_termination_date
3390: from per_periods_of_service pps, per_all_assignments_f paaf
3391: where paaf.assignment_id = p_assignment_id
3392: and p_date_paid between paaf.effective_start_date and paaf.effective_end_date
3393: and paaf.period_of_service_id = pps.period_of_service_id ;
3394:

Line 3714: from per_periods_of_service pps, per_all_assignments_f paaf

3710:
3711:
3712: cursor csr_get_curr_atd is
3713: select pps.actual_termination_date
3714: from per_periods_of_service pps, per_all_assignments_f paaf
3715: where paaf.assignment_id = p_assignment_id
3716: and p_date_paid between paaf.effective_start_date and paaf.effective_end_date
3717: and paaf.period_of_service_id = pps.period_of_service_id ;
3718:

Line 3775: from per_periods_of_service pps

3771: and p_date_paid between effective_start_date and effective_end_date;
3772:
3773: cursor csr_rehired_assignment (c_year_start_paid date) is
3774: select distinct paa.assignment_id, pps.actual_termination_date, nvl(pps.final_process_date, to_date('31/12/4712','dd/mm/yyyy')) final_process_date
3775: from per_periods_of_service pps
3776: ,per_all_assignments_f paa
3777: where pps.person_id = (
3778: select person_id
3779: from per_all_assignments_f paa1