APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_PARTIES

Line 2514: hz_parties

2510: IS
2511: CURSOR party_cur IS
2512: SELECT party_type
2513: from
2514: hz_parties
2515: where party_id = p_party_id
2516: and status = 'A';
2517: CURSOR org_contact IS
2518: select a.org_contact_id

Line 2566: HZ_PARTIES a, HZ_PARTY_SITES b

2562: IS
2563: CURSOR party_cur IS
2564: SELECT a.party_type, a.party_id
2565: from
2566: HZ_PARTIES a, HZ_PARTY_SITES b
2567: where
2568: a.status = 'A'
2569: AND b.status = 'A'
2570: and b.party_site_id = p_party_site_id

Line 2688: HZ_PARTIES

2684: IS
2685: CURSOR party_cur IS
2686: SELECT party_type
2687: from
2688: HZ_PARTIES
2689: where party_id = p_party_id and status ='A';
2690:
2691: CURSOR cust_cur IS
2692: SELECT party_id

Line 2924: from hz_parties

2920: NVL(account_termination_date, sysdate));
2921:
2922: CURSOR party_rec IS
2923: select party_type
2924: from hz_parties
2925: where party_id = p_party_id
2926: AND status = 'A';
2927:
2928: CURSOR account_user_cur IS