APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on PER_ALL_PEOPLE_F
Line 206: FROM per_all_people_f e
202: IS
203: CURSOR cur_val_contact
204: IS
205: SELECT 'Y' 206: FROM per_all_people_f e 207: WHERE e.current_employee_flag = 'Y'
208: AND TRUNC (SYSDATE) BETWEEN NVL (e.effective_start_date,
209: SYSDATE - 1
210: )
Line 219: FROM per_all_people_f e
215: -- CWK contract worket
216: CURSOR cur_val_contact2
217: IS
218: SELECT 'Y' 219: FROM per_all_people_f e 220: WHERE e.current_npw_flag = 'Y'
221: AND TRUNC (SYSDATE) BETWEEN NVL (e.effective_start_date,
222: SYSDATE - 1
223: )