APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 591: l_table_name IN VARCHAR2, -- HZ_CUST_PROF_CLASS_AMTS

587:
588: --Phase 6
589: PROCEDURE upgrade_profile_class_amount
590: (l_table_owner IN VARCHAR2, -- AR
591: l_table_name IN VARCHAR2, -- HZ_CUST_PROF_CLASS_AMTS
592: l_script_name IN VARCHAR2, -- arlccpca.sql
593: l_worker_id IN VARCHAR2,
594: l_num_workers IN VARCHAR2,
595: l_batch_size IN VARCHAR2)

Line 625: FROM hz_cust_prof_class_amts cpa,

621: , cpa.jgzz_attribute3 PENALTY_FIXED_AMOUNT
622: --{TCA Validation
623: , DECODE(cpa.jgzz_attribute7,NULL,cpa.interest_rate,NULL) interest_rate
624: --}
625: FROM hz_cust_prof_class_amts cpa,
626: ar_charge_schedules cs
627: WHERE cpa.rowid >= p_start_rowid
628: AND cpa.rowid <= p_end_rowid
629: AND cs.SCHEDULE_NAME(+) = DECODE(cpa.jgzz_attribute7,

Line 700: UPDATE hz_cust_prof_class_amts

696: EXIT;
697: END IF;
698:
699: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
700: UPDATE hz_cust_prof_class_amts
701: SET EXCHANGE_RATE_TYPE = l_EXCHANGE_RATE_TYPE(i),
702: MIN_FC_INVOICE_OVERDUE_TYPE = l_MIN_FC_INVOICE_OVERDUE_TYPE(i),
703: MIN_FC_INVOICE_AMOUNT = l_MIN_FC_INVOICE_AMOUNT(i),
704: MIN_FC_BALANCE_OVERDUE_TYPE = l_MIN_FC_BALANCE_OVERDUE_TYPE(i),

Line 790: FROM hz_cust_prof_class_amts

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'
792: GROUP BY PROFILE_CLASS_ID) cpa
793: WHERE cp.rowid >= p_start_rowid
794: AND cp.rowid <= p_end_rowid