APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2898: FROM hz_cust_account_roles

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

Line 2906: FROM hz_cust_account_roles

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

Line 2914: FROM hz_cust_account_roles

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

Line 2924: hz_cust_account_roles role

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