APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_CUST_ACCOUNT_ROLES

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

Line 2874: from hz_cust_accounts a, hz_cust_account_roles b

2870: AND status = 'A';
2871:
2872: CURSOR account_user_cur IS
2873: select a.cust_account_id
2874: from hz_cust_accounts a, hz_cust_account_roles b
2875: where a.cust_account_id = b.cust_account_id
2876: and b.party_id = p_party_id
2877: and b.role_type = 'ACCOUNT_USER'
2878: AND b.status = 'A'

Line 2982: FROM hz_cust_account_roles

2978: )
2979: IS
2980: CURSOR C_active_contact (p_party_id NUMBER) IS
2981: SELECT cust_account_role_id, status
2982: FROM hz_cust_account_roles
2983: WHERE party_id = p_party_id
2984: AND cust_account_id = p_cust_account_id
2985: AND role_type ='CONTACT'
2986: AND cust_acct_site_id is null

Line 2991: FROM hz_cust_account_roles

2987: and status = 'A';
2988:
2989: CURSOR C_inactive_contact (p_party_id NUMBER) IS
2990: SELECT cust_account_role_id, status
2991: FROM hz_cust_account_roles
2992: WHERE party_id = p_party_id
2993: AND cust_account_id = p_cust_account_id
2994: AND role_type ='CONTACT'
2995: AND cust_acct_site_id is null