DBA Data[Home] [Help]

APPS.ASO_ORDER_INT dependencies on HZ_PARTIES

Line 3270: HZ_PARTIES a, HZ_PARTY_SITES b

3266: IS
3267: CURSOR relationship_cur IS
3268: SELECT a.party_type
3269: from
3270: HZ_PARTIES a, HZ_PARTY_SITES b
3271: where
3272: a.status = 'A'
3273: and b.party_site_id = p_party_site_id
3274: and b.party_id = a.party_id;

Line 3327: HZ_PARTIES

3323: IS
3324: CURSOR relationship_cur IS
3325: SELECT party_type
3326: from
3327: HZ_PARTIES
3328: where party_id = p_party_id and status ='A';
3329: CURSOR org_contact IS
3330: select a.org_contact_id
3331: from