APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on HZ_CUST_ACCOUNTS

Line 231: FROM HZ_CUST_ACCOUNTS WHERE

227: --check if any a/c has been created for the ORG and if that a/c is
228: -- associated with this user(B2B/B2C)
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' ;

Line 262: FROM HZ_CUST_ACCOUNTS

258:
259: --check if any a/c has been created for this user
260:
261: SELECT COUNT(*) into L_ACCT_CNT
262: FROM HZ_CUST_ACCOUNTS
263: WHERE PARTY_ID =p_party_id
264: AND STATUS = 'A';
265:
266: