APPS.IGF_SL_CL_ORIG_ACK dependencies on HZ_RELATIONSHIPS

Line 5529: CURSOR c_get_relationship( p_subject_id hz_relationships.subject_id%TYPE,

5525: -- pssahni 18-Jan-2005 Added functionality to check if relationship
5526: -- already exsist between the student and borrower
5527: ------------------------------------------------------------------
5528: -- Get the details of relationship
5529: CURSOR c_get_relationship( p_subject_id hz_relationships.subject_id%TYPE,
5530: p_object_id hz_relationships.object_id%TYPE
5531: ) IS
5532: SELECT relationship_type
5533: FROM hz_relationships

Line 5530: p_object_id hz_relationships.object_id%TYPE

5526: -- already exsist between the student and borrower
5527: ------------------------------------------------------------------
5528: -- Get the details of relationship
5529: CURSOR c_get_relationship( p_subject_id hz_relationships.subject_id%TYPE,
5530: p_object_id hz_relationships.object_id%TYPE
5531: ) IS
5532: SELECT relationship_type
5533: FROM hz_relationships
5534: WHERE subject_id = p_subject_id

Line 5533: FROM hz_relationships

5529: CURSOR c_get_relationship( p_subject_id hz_relationships.subject_id%TYPE,
5530: p_object_id hz_relationships.object_id%TYPE
5531: ) IS
5532: SELECT relationship_type
5533: FROM hz_relationships
5534: WHERE subject_id = p_subject_id
5535: AND object_id = p_object_id;
5536:
5537: l_relationship c_get_relationship%ROWTYPE;

Line 5544: l_n_relationship_id hz_relationships.relationship_id%TYPE;

5540: l_v_msg_data VARCHAR2(1000);
5541: l_v_return_status VARCHAR2(10);
5542: l_d_last_update_date DATE;
5543: l_n_location_ovn hz_locations.object_version_number%TYPE;
5544: l_n_relationship_id hz_relationships.relationship_id%TYPE;
5545: l_n_party_id hz_parties.party_id%TYPE;
5546: l_v_party_number hz_parties.party_number%TYPE;
5547:
5548: