APPS.HR_MEE_VIEWS_GEN dependencies on PER_CONTACT_RELATIONSHIPS

Line 230: p_person_id IN per_contact_relationships.person_id%TYPE

226: PRAGMA RESTRICT_REFERENCES
227: (get_currency_format, WNDS);
228:
229: FUNCTION GET_CONTACTS_TYPE_LIST(
230: p_person_id IN per_contact_relationships.person_id%TYPE
231: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
232: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
233: RETURN VARCHAR2;
234:

Line 231: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

227: (get_currency_format, WNDS);
228:
229: FUNCTION GET_CONTACTS_TYPE_LIST(
230: p_person_id IN per_contact_relationships.person_id%TYPE
231: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
232: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
233: RETURN VARCHAR2;
234:
235: FUNCTION is_emergency_contact(

Line 236: p_person_id IN per_contact_relationships.person_id%TYPE

232: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
233: RETURN VARCHAR2;
234:
235: FUNCTION is_emergency_contact(
236: p_person_id IN per_contact_relationships.person_id%TYPE
237: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
238: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
239: RETURN NUMBER;
240:

Line 237: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

233: RETURN VARCHAR2;
234:
235: FUNCTION is_emergency_contact(
236: p_person_id IN per_contact_relationships.person_id%TYPE
237: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
238: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
239: RETURN NUMBER;
240:
241: -- ------------------------------------------------------------------------