APPS.AR_LATE_CHARGE_UPG dependencies on JG_ZZ_II_INT_RATES_ALL

Line 36: l_table_name IN VARCHAR2, -- JG_ZZ_II_INT_RATES_ALL

32:
33: --Phase 5
34: PROCEDURE upgrade_schedule
35: (l_table_owner IN VARCHAR2, -- JG
36: l_table_name IN VARCHAR2, -- JG_ZZ_II_INT_RATES_ALL
37: l_script_name IN VARCHAR2, -- ar120lcjgr.sql
38: l_worker_id IN VARCHAR2,
39: l_num_workers IN VARCHAR2,
40: l_batch_size IN VARCHAR2)

Line 124: FROM JG_ZZ_II_INT_RATES_ALL

120: ,start_date_active as jg_start_date
121: ,end_date_active as jg_end_date
122: ,rank () over
123: (partition by lookup_type,lookup_code order by start_date_active asc) as rk
124: FROM JG_ZZ_II_INT_RATES_ALL
125: WHERE lookup_type IN ('JGZZ_INT_INV_DAILY_RATE','JGZZ_INT_INV_MONTHLY_RATE')
126: AND rowid >= l_start_rowid
127: AND rowid <= l_end_rowid)
128: WHERE rk = 1;

Line 169: FROM JG_ZZ_II_INT_RATES_ALL jg,

165: ,jg.enabled_flag as jg_enabled_flag
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

Line 213: FROM JG_ZZ_II_INT_RATES_ALL jg,

209: ,jg.start_date_active as jg_start_date
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