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 3329: from per_assignments_f paf

3325: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3326: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))
3327: and exists
3328: (select 1
3329: from per_assignments_f paf
3330: where paf.assignment_id = paa.assignment_id
3331: and paf.effective_start_date <= ppa.effective_date
3332: and paf.effective_end_date >= trunc(ppa.effective_date,'Y')
3333: )

Line 3445: per_assignments_f paf

3441: /* Bug 6837510 */
3442: cursor cur_get_location(cp_asgact_id number) is
3443: select paf.LOCATION_ID
3444: from pay_assignment_actions paa,
3445: per_assignments_f paf
3446: where paa.assignment_action_id = cp_asgact_id
3447: and paf.assignment_id = paa.assignment_id;
3448:
3449: /* Bug 15908332 */

Line 3883: from per_assignments_f paf

3879: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3880: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))
3881: and exists
3882: (select 1
3883: from per_assignments_f paf
3884: where paf.assignment_id = paa.assignment_id
3885: and paf.effective_start_date <= ppa.effective_date
3886: and paf.effective_end_date >= trunc(ppa.effective_date,'Y')
3887: )