DBA Data[Home] [Help]

APPS.PER_COBRA_ECI dependencies on PER_PEOPLE_F

Line 37: FROM per_people_f PPF

33: -- cobra coverage.
34: --
35: CURSOR C1 IS
36: SELECT PPF.registered_disabled_flag
37: FROM per_people_f PPF
38: WHERE PPF.person_id = p_person_id
39: AND PPF.registered_disabled_flag = 'Y'
40: AND (p_qualifying_start_date
41: BETWEEN PPF.effective_start_date

Line 3804: from per_people_f a,

3800: p_coverage_end_date in date) return boolean is
3801: --
3802: cursor c1 is
3803: select a.date_of_birth
3804: from per_people_f a,
3805: per_contact_relationships b
3806: where a.person_id = b.contact_person_id
3807: and b.contact_relationship_id = p_contact_relationship_id;
3808: --