DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on HR_GENERAL

Line 1961: HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) Full_Contact_Type

1957: CURSOR lc_get_contact(pp_person_id IN NUMBER, pp_contact_id IN NUMBER, pp_effective_date IN DATE)
1958: IS
1959: select pcr.contact_type Contact_Type,
1960: decode(pcr.contact_type,'EMRG','Y','N') Emergency_Contact,
1961: HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) Full_Contact_Type
1962: from per_contact_relationships pcr,
1963: per_all_people_f per
1964: where pcr.person_id = pp_person_id
1965: and pcr.contact_person_id = pp_contact_id