DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 400: FROM per_person_type_usages_f pptuf

396: --14591849 Start1
397: AND NOT EXISTS
398: (
399: SELECT 1
400: FROM per_person_type_usages_f pptuf
401: WHERE pptuf.person_id = papf.person_id
402: AND p_end_date BETWEEN pptuf.effective_start_date
403: AND pptuf.effective_end_date
404: AND pptuf.person_type_id IN

Line 472: FROM per_person_type_usages_f pptuf

468: --14591849 Start2
469: AND NOT EXISTS
470: (
471: SELECT 1
472: FROM per_person_type_usages_f pptuf
473: WHERE pptuf.person_id = papf.person_id
474: AND p_end_date BETWEEN pptuf.effective_start_date
475: AND pptuf.effective_end_date
476: AND pptuf.person_type_id IN