APPS.OKC_TERMS_MIGRATE_GRP dependencies on PER_ALL_PEOPLE_F

Line 3223: SELECT person_id FROM PER_ALL_PEOPLE_F

3219: CURSOR c_get_user_id_csr(p_user_name IN VARCHAR2) IS
3220: SELECT user_id FROM fnd_user WHERE user_name LIKE p_user_name;
3221:
3222: CURSOR c_get_person_id(p_person_name IN VARCHAR2) IS
3223: SELECT person_id FROM PER_ALL_PEOPLE_F
3224: WHERE full_name = p_person_name;
3225:
3226:
3227:

Line 3657: FROM per_all_people_f e

3653: IS
3654: CURSOR cur_val_contact
3655: IS
3656: SELECT 'Y'
3657: FROM per_all_people_f e
3658: WHERE e.current_employee_flag = 'Y'
3659: AND TRUNC (SYSDATE) BETWEEN NVL (e.effective_start_date,
3660: SYSDATE - 1
3661: )

Line 3670: FROM per_all_people_f e

3666: -- CWK contract worket
3667: CURSOR cur_val_contact2
3668: IS
3669: SELECT 'Y'
3670: FROM per_all_people_f e
3671: WHERE e.current_npw_flag = 'Y'
3672: AND TRUNC (SYSDATE) BETWEEN NVL (e.effective_start_date,
3673: SYSDATE - 1
3674: )