APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_CUST_ACCT_SITES

Line 2523: hz_cust_site_uses a, hz_cust_acct_sites b

2519: and b.party_id = a.party_id;
2520: CURSOR site_use_cur IS
2521: select a.site_use_id, b.status,a.status
2522: from
2523: hz_cust_site_uses a, hz_cust_acct_sites b
2524: where
2525: b.cust_account_id = p_cust_account_id
2526: and b.party_site_id = p_party_site_id
2527: and a.cust_acct_site_id = b.cust_acct_site_id

Line 2672: hz_cust_account_roles a, hz_cust_acct_sites c

2668:
2669: CURSOR cust_role(l_party_id number) IS
2670: select a.cust_account_role_id, a.status
2671: from
2672: hz_cust_account_roles a, hz_cust_acct_sites c
2673: --,hz_role_responsibility d
2674: where
2675: a.role_type = 'CONTACT'
2676: and a.party_id = l_party_id

Line 2689: hz_cust_account_roles a, hz_cust_acct_sites c

2685:
2686: CURSOR cust_role_exists(l_party_id number) IS
2687: select 'Y'
2688: from
2689: hz_cust_account_roles a, hz_cust_acct_sites c
2690: where
2691: a.role_type = 'CONTACT'
2692: and a.party_id = l_party_id
2693: and a.cust_account_id = p_cust_account_id