APPS.HR_MEE_VIEWS_GEN dependencies on PER_CONTACT_RELATIONSHIPS

Line 1950: p_person_id IN per_contact_relationships.person_id%TYPE

1946: ||===========================================================================
1947: */
1948:
1949: FUNCTION get_contacts_type_list(
1950: p_person_id IN per_contact_relationships.person_id%TYPE
1951: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
1952: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1953: RETURN VARCHAR2
1954: IS

Line 1951: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

1947: */
1948:
1949: FUNCTION get_contacts_type_list(
1950: p_person_id IN per_contact_relationships.person_id%TYPE
1951: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
1952: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
1953: RETURN VARCHAR2
1954: IS
1955:

Line 1962: from per_contact_relationships pcr,

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

Line 2008: p_person_id IN per_contact_relationships.person_id%TYPE

2004: ||===========================================================================
2005: */
2006:
2007: FUNCTION is_emergency_contact(
2008: p_person_id IN per_contact_relationships.person_id%TYPE
2009: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
2010: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
2011: RETURN NUMBER
2012: IS

Line 2009: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

2005: */
2006:
2007: FUNCTION is_emergency_contact(
2008: p_person_id IN per_contact_relationships.person_id%TYPE
2009: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
2010: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
2011: RETURN NUMBER
2012: IS
2013:

Line 2018: from per_contact_relationships pcr,

2014: lv_primary VARCHAR2(1) DEFAULT null;
2015:
2016: BEGIN
2017: select pcr.primary_contact_flag into lv_primary
2018: from per_contact_relationships pcr,
2019: per_all_people_f per
2020: where pcr.person_id = p_person_id
2021: and pcr.contact_person_id = p_contact_id
2022: and pcr.contact_person_id = per.person_id