APPS.AST_UWQ_SEL_PKG dependencies on HZ_RELATIONSHIPS

Line 694: FROM hz_parties p, hz_relationships rel

690: PROCEDURE GetDtlsFromConNum IS
691: /* kmahajan - just pass back the Party_id of the relationship instead
692: CURSOR C_getDtlsFromConNum(x_contactNum varchar2 ) IS
693: SELECT rel.subject_id, rel.object_id
694: FROM hz_parties p, hz_relationships rel
695: WHERE p.party_number = x_contactNum
696: AND p.party_id = rel.party_id
697: AND rel.subject_type = 'PERSON'
698: AND rel.object_table_name = 'HZ_PARTIES'

Line 851: HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid and

847: HZ_PARTY_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid;
848: */
849: CURSOR C_GetSubObj(p_rel_partyid number) is
850: SELECT object_id, subject_id from
851: HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid and
852: object_type = 'ORGANIZATION' and subject_type = 'PERSON';
853:
854: l_rel_partyid number := NULL;
855: l_partyIDNext number;