DBA Data[Home] [Help]

APPS.HRWSECI dependencies on PER_PEOPLE_F

Line 32: FROM per_people_f PPF

28: -- cobra coverage.
29: --
30: CURSOR C1 IS
31: SELECT PPF.registered_disabled_flag
32: FROM per_people_f PPF
33: WHERE PPF.person_id = p_person_id
34: AND PPF.registered_disabled_flag = 'Y'
35: AND (p_qualifying_start_date
36: BETWEEN PPF.effective_start_date

Line 3160: from per_people_f a,

3156: p_coverage_end_date in date) return boolean is
3157: --
3158: cursor c1 is
3159: select a.date_of_birth
3160: from per_people_f a,
3161: per_contact_relationships b
3162: where a.person_id = b.contact_person_id
3163: and b.contact_relationship_id = p_contact_relationship_id;
3164: --