DBA Data[Home] [Help]

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 3490: from pa_employees p ,

3486: -- the specific dates.
3487:
3488: CURSOR l_full_name_csr(p_person_id IN NUMBER ) IS
3489: SELECT 'X'
3490: from pa_employees p ,
3491: fnd_user u
3492: WHERE
3493: EXISTS (SELECT null FROM per_assignments_f a
3494: WHERE p.person_id = a.person_id