APPS.HR_MEE_VIEWS_GEN dependencies on PER_CONTACT_RELATIONSHIPS

Line 1993: p_person_id IN per_contact_relationships.person_id%TYPE

1989: ||===========================================================================
1990: */
1991:
1992: FUNCTION get_contacts_type_list(
1993: p_person_id IN per_contact_relationships.person_id%TYPE
1994: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
1995: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1996: RETURN VARCHAR2
1997: IS

Line 1994: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

1990: */
1991:
1992: FUNCTION get_contacts_type_list(
1993: p_person_id IN per_contact_relationships.person_id%TYPE
1994: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
1995: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1996: RETURN VARCHAR2
1997: IS
1998:

Line 2005: from per_contact_relationships pcr,

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
2009: and pcr.contact_person_id = per.person_id

Line 2051: p_person_id IN per_contact_relationships.person_id%TYPE

2047: ||===========================================================================
2048: */
2049:
2050: FUNCTION is_emergency_contact(
2051: p_person_id IN per_contact_relationships.person_id%TYPE
2052: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
2053: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
2054: RETURN NUMBER
2055: IS

Line 2052: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

2048: */
2049:
2050: FUNCTION is_emergency_contact(
2051: p_person_id IN per_contact_relationships.person_id%TYPE
2052: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
2053: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
2054: RETURN NUMBER
2055: IS
2056:

Line 2061: from per_contact_relationships pcr,

2057: lv_primary VARCHAR2(1) DEFAULT null;
2058:
2059: BEGIN
2060: select pcr.primary_contact_flag into lv_primary
2061: from per_contact_relationships pcr,
2062: per_all_people_f per
2063: where pcr.person_id = p_person_id
2064: and pcr.contact_person_id = p_contact_id
2065: and pcr.contact_person_id = per.person_id