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_CA_YEER_PKG dependencies on PER_ASSIGNMENTS_F

Line 2960: from per_assignments_f paf

2956: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
2957: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))
2958: and exists
2959: (select 1
2960: from per_assignments_f paf
2961: where paf.assignment_id = paa.assignment_id
2962: and paf.effective_start_date <= ppa.effective_date
2963: and paf.effective_end_date >= trunc(ppa.effective_date,'Y')
2964: )

Line 3418: from per_assignments_f paf

3414: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3415: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))
3416: and exists
3417: (select 1
3418: from per_assignments_f paf
3419: where paf.assignment_id = paa.assignment_id
3420: and paf.effective_start_date <= ppa.effective_date
3421: and paf.effective_end_date >= trunc(ppa.effective_date,'Y')
3422: )