APPS.GMS_AWARD_PVT dependencies on PA_EMPLOYEES

Line 1341: pa_employees e,

1337:
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

Line 3491: from pa_employees p ,

3487: -- the specific dates.
3488:
3489: CURSOR l_full_name_csr(p_person_id IN NUMBER ) IS
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