APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2900: FROM hz_cust_account_roles

2896:
2897:
2898: CURSOR c_get_cust_id(in_cust_account_role_id in number) IS
2899: SELECT cust_account_id
2900: FROM hz_cust_account_roles
2901: where cust_account_role_id = in_cust_account_role_id;
2902:
2903: CURSOR c_cust_role_site( in_cust_account_role_id in number) IS
2904: SELECT status,

Line 2908: FROM hz_cust_account_roles

2904: SELECT status,
2905: role_type,
2906: cust_account_id,
2907: cust_acct_site_id
2908: FROM hz_cust_account_roles
2909: where cust_account_role_id = in_cust_account_role_id;
2910:
2911: CURSOR c_cust_account_role( in_cust_account_role_id in number) IS
2912: SELECT cust_acct_site_id,

Line 2916: FROM hz_cust_account_roles

2912: SELECT cust_acct_site_id,
2913: status,
2914: role_type,
2915: cust_account_id
2916: FROM hz_cust_account_roles
2917: where cust_account_role_id = in_cust_account_role_id;
2918:
2919: CURSOR c_org_contact(in_org_contact_id in number,
2920: in_cust_account_id in number) IS

Line 2926: hz_cust_account_roles role

2922: role.cust_acct_site_id
2923: FROM hz_org_contacts org,
2924: hz_relationships rel,
2925: hz_cust_accounts acct,
2926: hz_cust_account_roles role
2927: WHERE org.org_Contact_id = in_org_contact_id
2928: AND org.party_relationship_id = rel.relationship_id
2929: AND rel.object_id=acct.party_id
2930: AND rel.subject_table_name='HZ_PARTIES'