DBA Data[Home] [Help]

APPS.PAY_FR_COURT_ORDERS dependencies on PER_ALL_PEOPLE_F

Line 449: FROM per_all_people_f

445: and ( pcr.date_start is NULL OR p_date_earned BETWEEN
446: pcr.date_start AND NVL(pcr.date_end, p_date_earned) )
447: and (pcr.date_start IS NOT NULL OR
448: EXISTS (SELECT person_id
449: FROM per_all_people_f
450: WHERE person_id = pcr.contact_person_id
451: AND p_date_earned BETWEEN
452: effective_start_date AND effective_end_date));
453: