DBA Data[Home] [Help]

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_PARTIES

Line 2462: hz_parties

2458: IS
2459: CURSOR party_cur IS
2460: SELECT party_type
2461: from
2462: hz_parties
2463: where party_id = p_party_id
2464: and status = 'A';
2465: CURSOR org_contact IS
2466: select a.org_contact_id

Line 2514: HZ_PARTIES a, HZ_PARTY_SITES b

2510: IS
2511: CURSOR party_cur IS
2512: SELECT a.party_type, a.party_id
2513: from
2514: HZ_PARTIES a, HZ_PARTY_SITES b
2515: where
2516: a.status = 'A'
2517: AND b.status = 'A'
2518: and b.party_site_id = p_party_site_id

Line 2632: HZ_PARTIES

2628: IS
2629: CURSOR party_cur IS
2630: SELECT party_type
2631: from
2632: HZ_PARTIES
2633: where party_id = p_party_id and status ='A';
2634:
2635: CURSOR cust_cur IS
2636: SELECT party_id

Line 2868: from hz_parties

2864: NVL(account_termination_date, sysdate));
2865:
2866: CURSOR party_rec IS
2867: select party_type
2868: from hz_parties
2869: where party_id = p_party_id
2870: AND status = 'A';
2871:
2872: CURSOR account_user_cur IS