DBA Data[Home] [Help]

APPS.HR_MEE_VIEWS_GEN dependencies on PER_CONTACT_RELATIONSHIPS

Line 217: p_person_id IN per_contact_relationships.person_id%TYPE

213: PRAGMA RESTRICT_REFERENCES
214: (get_currency_format, WNDS);
215:
216: FUNCTION GET_CONTACTS_TYPE_LIST(
217: p_person_id IN per_contact_relationships.person_id%TYPE
218: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:

Line 218: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

214: (get_currency_format, WNDS);
215:
216: FUNCTION GET_CONTACTS_TYPE_LIST(
217: p_person_id IN per_contact_relationships.person_id%TYPE
218: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(

Line 223: p_person_id IN per_contact_relationships.person_id%TYPE

219: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(
223: p_person_id IN per_contact_relationships.person_id%TYPE
224: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
225: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
226: RETURN NUMBER;
227:

Line 224: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE

220: RETURN VARCHAR2;
221:
222: FUNCTION is_emergency_contact(
223: p_person_id IN per_contact_relationships.person_id%TYPE
224: ,p_contact_id IN per_contact_relationships.contact_person_id%TYPE
225: ,p_effective_date IN DATE DEFAULT TRUNC(SYSDATE))
226: RETURN NUMBER;
227:
228: -- ------------------------------------------------------------------------