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_MX_TAX_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 2856: FROM per_periods_of_service pps , per_assignments_f paf

2852: AND l_date_paid BETWEEN start_date AND end_date;
2853:
2854: CURSOR csr_get_act_hire_date IS
2855: SELECT MIN(pps.date_start)
2856: FROM per_periods_of_service pps , per_assignments_f paf
2857: WHERE paf.assignment_id = P_ASSIGNMENT_ID
2858: AND pps.person_id = paf.person_id;
2859:
2860: CURSOR csr_get_compute_subsidy_flag IS /*bug#8438155*/

Line 3953: FROM per_periods_of_service pps

3949: CURSOR c_get_hire_date ( cp_person_id NUMBER
3950: ,cp_effective_date DATE ) IS
3951: SELECT MAX (pps.date_start), MAX(nvl(actual_termination_date,
3952: fnd_date.canonical_to_date('4712/12/31')))
3953: FROM per_periods_of_service pps
3954: WHERE pps.person_id = cp_person_id
3955: AND pps.date_start <= cp_effective_date;
3956: --bug 7604298
3957: CURSOR c_get_prev_term_date ( cp_person_id NUMBER

Line 3960: FROM per_periods_of_service pps

3956: --bug 7604298
3957: CURSOR c_get_prev_term_date ( cp_person_id NUMBER
3958: ,cp_effective_date DATE ) IS
3959: SELECT MAX(actual_termination_date)
3960: FROM per_periods_of_service pps
3961: WHERE pps.person_id = cp_person_id
3962: AND pps.date_start <= cp_effective_date
3963: AND pps.actual_termination_date IS NOT NULL;
3964: