APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_CUST_PROFILE_AMT_OBJ

Line 343: SELECT HZ_CUST_PROFILE_AMT_OBJ(

339: MESSAGE_TEXT_ID,
340: MULTIPLE_INTEREST_RATES_FLAG,
341: CHARGE_BEGIN_DATE,
342: CAST(MULTISET (
343: SELECT HZ_CUST_PROFILE_AMT_OBJ(
344: P_ACTION_TYPE,
345: NULL, -- COMMON_OBJ_ID
346: CUST_ACCT_PROFILE_AMT_ID,
347: CUST_ACCOUNT_PROFILE_ID,

Line 435: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID) AS HZ_CUST_PROFILE_AMT_OBJ_TBL))

431: MIN_INTEREST_CHARGE,
432: PENALTY_FIXED_AMOUNT,
433: PENALTY_SCHEDULE_ID )
434: FROM HZ_CUST_PROFILE_AMTS
435: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID) AS HZ_CUST_PROFILE_AMT_OBJ_TBL))
436: FROM HZ_CUSTOMER_PROFILES
437: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID AND SITE_USE_ID IS NULL;
438:
439: