DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PER_PERSON_TYPE_USAGES_F

Line 379: FROM per_person_type_usages_f pptuf

375: --14507939 Start1
376: AND NOT EXISTS
377: (
378: SELECT 1
379: FROM per_person_type_usages_f pptuf
380: WHERE pptuf.person_id = papf.person_id
381: AND p_end_date BETWEEN pptuf.effective_start_date
382: AND pptuf.effective_end_date
383: AND pptuf.person_type_id IN

Line 461: FROM per_person_type_usages_f pptuf

457: --14507939 Start2
458: AND NOT EXISTS
459: (
460: SELECT 1
461: FROM per_person_type_usages_f pptuf
462: WHERE pptuf.person_id = papf.person_id
463: AND p_end_date BETWEEN pptuf.effective_start_date
464: AND pptuf.effective_end_date
465: AND pptuf.person_type_id IN