DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on HZ_ROLE_RESPONSIBILITY_OBJ

Line 227: SELECT HZ_ROLE_RESPONSIBILITY_OBJ(

223: AND R.SUBJECT_TYPE = 'PERSON'
224: AND OSR.OWNER_TABLE_NAME = 'HZ_PARTIES'
225: AND OSR.STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL), -- contact person ssm
226: CAST(MULTISET (
227: SELECT HZ_ROLE_RESPONSIBILITY_OBJ(
228: P_ACTION_TYPE,
229: NULL, --COMMON_OBJ_ID
230: RESPONSIBILITY_ID,
231: CUST_ACCOUNT_ROLE_ID,

Line 257: WHERE CUST_ACCOUNT_ROLE_ID = CAR.CUST_ACCOUNT_ROLE_ID) AS HZ_ROLE_RESPONSIBILITY_OBJ_TBL))

253: CREATION_DATE,
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