APPS.ASO_ORDER_INT dependencies on HZ_PARTIES

Line 3104: HZ_PARTIES a, HZ_PARTY_SITES b

3100: IS
3101: CURSOR relationship_cur IS
3102: SELECT a.party_type
3103: from
3104: HZ_PARTIES a, HZ_PARTY_SITES b
3105: where
3106: a.status = 'A'
3107: and b.party_site_id = p_party_site_id
3108: and b.party_id = a.party_id;

Line 3161: HZ_PARTIES

3157: IS
3158: CURSOR relationship_cur IS
3159: SELECT party_type
3160: from
3161: HZ_PARTIES
3162: where party_id = p_party_id and status ='A';
3163: CURSOR org_contact IS
3164: select a.org_contact_id
3165: from