APPS.AR_LATE_CHARGE_UPG dependencies on AR_CHARGE_SCHEDULES

Line 86: INTO ar_charge_schedules(

82: l_rows_processed := 0;
83:
84: INSERT ALL
85: WHEN rk = 1 THEN
86: INTO ar_charge_schedules(
87: SCHEDULE_ID
88: ,SCHEDULE_NAME
89: ,SCHEDULE_DESCRIPTION
90: ,OBJECT_VERSION_NUMBER

Line 97: (AR_CHARGE_SCHEDULES_S.NEXTVAL

93: ,LAST_UPDATED_BY
94: ,LAST_UPDATE_DATE
95: ,LAST_UPDATE_LOGIN)
96: VALUES
97: (AR_CHARGE_SCHEDULES_S.NEXTVAL
98: ,DECODE(lookup_type,'JGZZ_INT_INV_DAILY_RATE','D_UPG_','M_UPG_')||lookup_code
99: ,jg_description
100: ,1
101: ,-1

Line 170: ar_charge_schedules cs

166: ,jg.start_date_active as jg_start_date
167: ,jg.end_date_active as jg_end_date
168: ,cs.SCHEDULE_ID as schedule_id
169: FROM JG_ZZ_II_INT_RATES_ALL jg,
170: ar_charge_schedules cs
171: WHERE jg.lookup_type IN ('JGZZ_INT_INV_DAILY_RATE', 'JGZZ_INT_INV_MONTHLY_RATE')
172: AND DECODE(jg.lookup_type,'JGZZ_INT_INV_DAILY_RATE','D_UPG_','M_UPG_')||jg.lookup_code = cs.SCHEDULE_NAME
173: AND jg.rowid >= l_start_rowid
174: AND jg.rowid <= l_end_rowid;

Line 214: ar_charge_schedules cs,

210: ,jg.end_date_active as jg_end_date
211: ,ch.schedule_id as schedule_id
212: ,ch.schedule_header_id as schedule_header_id
213: FROM JG_ZZ_II_INT_RATES_ALL jg,
214: ar_charge_schedules cs,
215: ar_charge_schedule_hdrs ch
216: WHERE jg.lookup_type IN ('JGZZ_INT_INV_DAILY_RATE', 'JGZZ_INT_INV_MONTHLY_RATE')
217: AND DECODE(jg.lookup_type,'JGZZ_INT_INV_DAILY_RATE','D_UPG_','M_UPG_')||jg.lookup_code = cs.SCHEDULE_NAME
218: AND cs.schedule_id = ch.schedule_id

Line 285: ar_charge_schedules cs

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,
289: 'D','D_UPG_'||cpa.jgzz_attribute8,

Line 624: ar_charge_schedules cs

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