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.GMS_AWARD_PVT dependencies on PER_ASSIGNMENTS_F

Line 1324: FROM per_assignments_f pera,

1320: /* Bug 2534936
1321:
1322: cursor C_awd_manager is
1323: SELECT 1, gmsp.start_date_active, end_date_active
1324: FROM per_assignments_f pera,
1325: gms_personnel gmsp
1326: WHERE pera.person_id = g_award_rec.award_manager_id
1327: and trunc(sysdate) between pera.effective_start_date
1328: and pera.effective_end_date

Line 1342: per_assignments_f a

1338: CURSOR c_awd_manager IS
1339: SELECT 1
1340: FROM pa_implementations i,
1341: pa_employees e,
1342: per_assignments_f a
1343: WHERE e.business_group_id = i.business_group_id
1344: AND e.person_id = g_award_rec.award_manager_id
1345: AND a.person_id = e.person_id
1346: AND trunc(sysdate) BETWEEN a.effective_start_date AND a.effective_end_date

Line 3494: EXISTS (SELECT null FROM per_assignments_f a

3490: SELECT 'X'
3491: from pa_employees p ,
3492: fnd_user u
3493: WHERE
3494: EXISTS (SELECT null FROM per_assignments_f a
3495: WHERE p.person_id = a.person_id
3496: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
3497: AND a.primary_flag = 'Y'
3498: --AND a.assignment_type = 'E') --Bug 10124847