APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUST_PROFILE_CLASSES

Line 756: l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_CLASSES

752:
753: --Phase 7
754: PROCEDURE upgrade_profile_class
755: (l_table_owner IN VARCHAR2, -- AR
756: l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_CLASSES
757: l_script_name IN VARCHAR2, -- ar120lccpc.sql
758: l_worker_id IN VARCHAR2,
759: l_num_workers IN VARCHAR2,
760: l_batch_size IN VARCHAR2)

Line 785: FROM hz_cust_profile_classes cp,

781: , f_date(JGZZ_ATTRIBUTE6) CHARGE_BEGIN_DATE
782: , DECODE(JGZZ_ATTRIBUTE1,'Y','Y',
783: NVL(INTEREST_CHARGES,'N')) INTEREST_CHARGES
784: , f_NUMBER(JGZZ_ATTRIBUTE4) Message_text_id
785: FROM hz_cust_profile_classes cp,
786: (SELECT MAX(jgzz_attribute7) dom,
787: PROFILE_CLASS_ID
788: FROM hz_cust_prof_class_amts
789: WHERE jgzz_attribute7 = 'M'

Line 868: UPDATE hz_cust_profile_classes

864: EXIT;
865: END IF;
866:
867: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
868: UPDATE hz_cust_profile_classes
869: SET LATE_CHARGE_CALCULATION_TRX = l_LATE_CHARGE_CALCULATION_TRX(i),
870: CREDIT_ITEMS_FLAG = l_CREDIT_ITEMS_FLAG(i),
871: DISPUTED_TRANSACTIONS_FLAG = l_DISPUTED_TRANSACTIONS_FLAG(i),
872: LATE_CHARGE_TYPE = l_LATE_CHARGE_TYPE(i),