APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2728: hz_cust_account_roles a, hz_cust_acct_sites c

2724:
2725: CURSOR cust_role(l_party_id number) IS
2726: select a.cust_account_role_id, a.status
2727: from
2728: hz_cust_account_roles a, hz_cust_acct_sites c
2729: --,hz_role_responsibility d
2730: where
2731: a.role_type = 'CONTACT'
2732: and a.party_id = l_party_id

Line 2745: hz_cust_account_roles a, hz_cust_acct_sites c

2741:
2742: CURSOR cust_role_exists(l_party_id number) IS
2743: select 'Y'
2744: from
2745: hz_cust_account_roles a, hz_cust_acct_sites c
2746: where
2747: a.role_type = 'CONTACT'
2748: and a.party_id = l_party_id
2749: and a.cust_account_id = p_cust_account_id

Line 2930: from hz_cust_accounts a, hz_cust_account_roles b

2926: AND status = 'A';
2927:
2928: CURSOR account_user_cur IS
2929: select a.cust_account_id
2930: from hz_cust_accounts a, hz_cust_account_roles b
2931: where a.cust_account_id = b.cust_account_id
2932: and b.party_id = p_party_id
2933: and b.role_type = 'ACCOUNT_USER'
2934: AND b.status = 'A'

Line 3038: FROM hz_cust_account_roles

3034: )
3035: IS
3036: CURSOR C_active_contact (p_party_id NUMBER) IS
3037: SELECT cust_account_role_id, status
3038: FROM hz_cust_account_roles
3039: WHERE party_id = p_party_id
3040: AND cust_account_id = p_cust_account_id
3041: AND role_type ='CONTACT'
3042: AND cust_acct_site_id is null

Line 3047: FROM hz_cust_account_roles

3043: and status = 'A';
3044:
3045: CURSOR C_inactive_contact (p_party_id NUMBER) IS
3046: SELECT cust_account_role_id, status
3047: FROM hz_cust_account_roles
3048: WHERE party_id = p_party_id
3049: AND cust_account_id = p_cust_account_id
3050: AND role_type ='CONTACT'
3051: AND cust_acct_site_id is null