APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUST_PROFILE_CLASSES

Line 758: l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_CLASSES

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

Line 787: FROM hz_cust_profile_classes cp,

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

Line 870: UPDATE hz_cust_profile_classes

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