DBA Data[Home] [Help]

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