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 3799: from per_people_f a,

3795: p_coverage_end_date in date) return boolean is
3796: --
3797: cursor c1 is
3798: select a.date_of_birth
3799: from per_people_f a,
3800: per_contact_relationships b
3801: where a.person_id = b.contact_person_id
3802: and b.contact_relationship_id = p_contact_relationship_id;
3803: --