APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 64: Customer Account Role N N HZ_CUST_ACCOUNT_ROLES

60: all records for the particular contact from these TCA entity tables.
61:
62: Embedded TCA Entity Mandatory Multiple TCA Table Entities
63:
64: Customer Account Role N N HZ_CUST_ACCOUNT_ROLES
65: Role Responsibility N Y HZ_ROLE_RESPONSIBILITY
66:
67: */
68:

Line 178: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNT_ROLES'

174: ATTRIBUTE20)
175: FROM HZ_ORIG_SYS_REFERENCES OSR
176: WHERE
177: OSR.OWNER_TABLE_ID = CAR.CUST_ACCOUNT_ROLE_ID
178: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNT_ROLES'
179: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- acct contact ssm
180: CAST(MULTISET (
181: SELECT HZ_ORIG_SYS_REF_OBJ(
182: NULL, --P_ACTION_TYPE,

Line 258: FROM HZ_CUST_ACCOUNT_ROLES CAR, HZ_CUST_ACCOUNTS CA, HZ_RELATIONSHIPS R

254: LAST_UPDATE_DATE,
255: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
256: FROM HZ_ROLE_RESPONSIBILITY
257: WHERE CUST_ACCOUNT_ROLE_ID = CAR.CUST_ACCOUNT_ROLE_ID) AS HZ_ROLE_RESPONSIBILITY_OBJ_TBL))
258: FROM HZ_CUST_ACCOUNT_ROLES CAR, HZ_CUST_ACCOUNTS CA, HZ_RELATIONSHIPS R
259: WHERE
260: R.PARTY_ID = CAR.PARTY_ID
261: AND CA.PARTY_ID = R.OBJECT_ID
262: AND CAR.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID