APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_CUST_PROFILE_AMT_OBJ

Line 140: SELECT HZ_CUST_PROFILE_AMT_OBJ(

136: MESSAGE_TEXT_ID,
137: MULTIPLE_INTEREST_RATES_FLAG,
138: CHARGE_BEGIN_DATE,
139: CAST(MULTISET (
140: SELECT HZ_CUST_PROFILE_AMT_OBJ(
141: P_ACTION_TYPE,
142: NULL, -- COMMON_OBJ_ID
143: CUST_ACCT_PROFILE_AMT_ID,
144: CUST_ACCOUNT_PROFILE_ID,

Line 232: WHERE SITE_USE_ID = P_SITE_USE_ID) AS HZ_CUST_PROFILE_AMT_OBJ_TBL))

228: MIN_INTEREST_CHARGE,
229: PENALTY_FIXED_AMOUNT,
230: PENALTY_SCHEDULE_ID )
231: FROM HZ_CUST_PROFILE_AMTS
232: WHERE SITE_USE_ID = P_SITE_USE_ID) AS HZ_CUST_PROFILE_AMT_OBJ_TBL))
233: FROM HZ_CUSTOMER_PROFILES
234: WHERE SITE_USE_ID = P_SITE_USE_ID;
235:
236: