APPS.PER_JP_CONTACT_RELATIONSHIPS dependencies on PER_CONTACT_RELATIONSHIPS

Line 45: SELECT 'Y' FROM per_contact_relationships

41: p_contact_relationship_id NUMBER,
42: p_person_id NUMBER,
43: p_contact_person_id NUMBER) IS
44: --
45: SELECT 'Y' FROM per_contact_relationships
46: WHERE person_id = p_person_id
47: AND contact_person_id = p_contact_person_id
48: AND (p_contact_relationship_id IS NULL
49: OR (p_contact_relationship_id IS NOT NULL