APPS.HZ_RELATIONSHIP_TYPE_V2PUB dependencies on HZ_PARTIES

Line 899: FROM HZ_PARTIES

895:
896: CURSOR c_parties(p_party_id IN NUMBER, p_party_type IN VARCHAR2)
897: IS
898: SELECT 'Y' RESULT
899: FROM HZ_PARTIES
900: WHERE PARTY_ID = p_party_id
901: AND PARTY_TYPE = p_party_type;
902: r_parties c_parties%ROWTYPE;
903:

Line 941: -- if the instance_set_name belongs to hz_parties then

937: */
938:
939:
940: -- implementation using cursor for parties and ref cursor
941: -- if the instance_set_name belongs to hz_parties then
942: -- we do not use the dynamic sql formation
943: IF p_instance_set_name in ('PERSON', 'ORGANIZATION', 'GROUP') THEN
944: OPEN c_parties(p_instance_id, p_instance_set_name);
945: FETCH c_parties INTO l_ret;