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