DBA Data[Home] [Help]

APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on HZ_RELATIONSHIP_TYPES

Line 313: CURSOR get_party_rel_type_cur(cp_relationship_type hz_relationship_types.relationship_type%type) IS

309: p_directional_flag IN VARCHAR2,
310: p_emergency_contact_flag IN VARCHAR2
311: ) AS
312:
313: CURSOR get_party_rel_type_cur(cp_relationship_type hz_relationship_types.relationship_type%type) IS
314: SELECT 'X'
315: FROM hz_relationship_types
316: WHERE RELATIONSHIP_TYPE = cp_relationship_type AND
317: SUBJECT_TYPE= 'PERSON' AND

Line 315: FROM hz_relationship_types

311: ) AS
312:
313: CURSOR get_party_rel_type_cur(cp_relationship_type hz_relationship_types.relationship_type%type) IS
314: SELECT 'X'
315: FROM hz_relationship_types
316: WHERE RELATIONSHIP_TYPE = cp_relationship_type AND
317: SUBJECT_TYPE= 'PERSON' AND
318: OBJECT_TYPE='PERSON';
319: