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
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: