DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on HR_GENERAL

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

2000: CURSOR lc_get_contact(pp_person_id IN NUMBER, pp_contact_id IN NUMBER, pp_effective_date IN DATE)
2001: IS
2002: select pcr.contact_type Contact_Type,
2003: decode(pcr.contact_type,'EMRG','Y','N') Emergency_Contact,
2004: HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) Full_Contact_Type
2005: from per_contact_relationships pcr,
2006: per_all_people_f per
2007: where pcr.person_id = pp_person_id
2008: and pcr.contact_person_id = pp_contact_id