APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 128: -- Creating record in hz_cust_account_roles

124: ,p_message => ' message stack in account creation:'||x_msg_data);
125: raise_application_error(-20101,'Failed to create account:'||x_msg_data);
126:
127: end if;
128: -- Creating record in hz_cust_account_roles
129: /*
130: -- added check for bug 4291085,4480150
131: -- create a acct role only for party relationship
132: */

Line 233: FROM HZ_CUST_ACCOUNT_ROLES

229:
230: SELECT COUNT(*) into L_ACCT_CNT
231: FROM HZ_CUST_ACCOUNTS WHERE
232: CUST_ACCOUNT_ID IN( SELECT CUST_ACCOUNT_ID
233: FROM HZ_CUST_ACCOUNT_ROLES
234: WHERE PARTY_ID = p_party_id
235: AND STATUS = 'A') AND STATUS='A' ;
236:
237:

Line 851: -- Creating record in hz_cust_account_roles

847: ,p_message => ' message stack in account creation:'||x_msg_data);
848: raise_application_error(-20101,'Failed to create account:'||x_msg_data);
849:
850: end if;
851: -- Creating record in hz_cust_account_roles
852:
853: if x_cust_account_id is not null then
854:
855: cust_acct_roles_rec.cust_account_id := x_cust_account_id;