APPS.AR_LATE_CHARGE_UPG dependencies on AR_CHARGE_SCHEDULE_HDRS

Line 133: INTO ar_charge_schedule_hdrs(

129:
130:
131: INSERT ALL
132: WHEN 1 = 1 THEN
133: INTO ar_charge_schedule_hdrs(
134: SCHEDULE_HEADER_ID
135: ,SCHEDULE_ID
136: ,SCHEDULE_HEADER_TYPE
137: ,AGING_BUCKET_ID

Line 148: (AR_CHARGE_SCHEDULE_HDRS_S.NEXTVAL

144: ,LAST_UPDATED_BY
145: ,LAST_UPDATE_DATE
146: ,LAST_UPDATE_LOGIN)
147: VALUES
148: (AR_CHARGE_SCHEDULE_HDRS_S.NEXTVAL
149: ,schedule_id
150: ,'RATE'
151: ,6
152: ,jg_start_date

Line 215: ar_charge_schedule_hdrs ch

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
219: AND jg.start_date_active = ch.start_date