APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUST_PROFILE_AMTS

Line 252: l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_AMTS

248:
249: --Phase 6
250: PROCEDURE upgrade_profile_amount
251: (l_table_owner IN VARCHAR2, -- AR
252: l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_AMTS
253: l_script_name IN VARCHAR2, -- ar120lccpa.sql
254: l_worker_id IN VARCHAR2,
255: l_num_workers IN VARCHAR2,
256: l_batch_size IN VARCHAR2)

Line 284: FROM hz_cust_profile_amts cpa,

280: , cpa.jgzz_attribute3 PENALTY_FIXED_AMOUNT
281: --{TCA Validation
282: , DECODE(cpa.jgzz_attribute7,NULL,cpa.interest_rate,NULL) interest_rate
283: --}
284: FROM hz_cust_profile_amts cpa,
285: ar_charge_schedules cs
286: WHERE cpa.rowid >= p_start_rowid
287: AND cpa.rowid <= p_end_rowid
288: AND cs.SCHEDULE_NAME(+) = DECODE(cpa.jgzz_attribute7,

Line 359: UPDATE hz_cust_profile_amts

355: EXIT;
356: END IF;
357:
358: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
359: UPDATE hz_cust_profile_amts
360: SET EXCHANGE_RATE_TYPE = l_EXCHANGE_RATE_TYPE(i),
361: MIN_FC_INVOICE_OVERDUE_TYPE = l_MIN_FC_INVOICE_OVERDUE_TYPE(i),
362: MIN_FC_INVOICE_AMOUNT = l_MIN_FC_INVOICE_AMOUNT(i),
363: MIN_FC_BALANCE_OVERDUE_TYPE = l_MIN_FC_BALANCE_OVERDUE_TYPE(i),

Line 450: FROM hz_cust_profile_amts

446: , decode(cons_inv_flag,'Y', decode(cons_bill_level,NULL,'SITE',NULL), NULL) cons_bill_level
447: FROM hz_customer_profiles cp,
448: (SELECT MAX(jgzz_attribute7) dom,
449: CUST_ACCOUNT_PROFILE_ID
450: FROM hz_cust_profile_amts
451: WHERE jgzz_attribute7 = 'M'
452: GROUP BY CUST_ACCOUNT_PROFILE_ID) cpa
453: WHERE cp.rowid >= p_start_rowid
454: AND cp.rowid <= p_end_rowid