APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ_TBL

Line 106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))

102: FROM HZ_ORIG_SYS_REFERENCES
103: WHERE
104: OWNER_TABLE_ID = RELATED_CUST_ACCOUNT_ID
105: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
107: FROM HZ_CUST_ACCT_RELATE
108: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID;
109:
110: BEGIN

Line 777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

773: FROM HZ_ORIG_SYS_REFERENCES OSR
774: WHERE
775: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),
781: NULL, --CUST_PROFILE_OBJ,

Line 1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),

1233: FROM HZ_ORIG_SYS_REFERENCES OSR
1234: WHERE
1235: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),
1241: NULL, --CUST_PROFILE_OBJ,