DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on PER_ALL_PEOPLE_F

Line 1465: per_all_people_f per

1461: cursor c_contact is
1462: select pcr.contact_person_id ,
1463: pcr.contact_relationship_id
1464: from per_contact_relationships pcr,
1465: per_all_people_f per
1466: where pcr.person_id = p_person_id
1467: and pcr.contact_person_id = per.person_id
1468: and pcr.personal_flag = 'Y'
1469: and p_effective_date between per.effective_start_date and per.effective_end_date