DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_UPG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 955: ar_payment_schedules_all psch,

951: psch.rowid as psch_rowid,
952: csu.last_accrue_charge_date as csu_last_charge_date,
953: rank () over (partition by adj.payment_schedule_id order by adjustment_id desc) as rk
954: FROM hz_cust_site_uses_all csu,
955: ar_payment_schedules_all psch,
956: ar_adjustments_all adj
957: WHERE csu.rowid >= p_start_rowid
958: AND csu.rowid <= p_end_rowid
959: AND csu.last_accrue_charge_date IS NOT NULL

Line 1020: UPDATE ar_payment_schedules_all

1016: EXIT;
1017: END IF;
1018:
1019: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
1020: UPDATE ar_payment_schedules_all
1021: SET last_charge_date = l_csu_last_charge_date(i)
1022: WHERE rowid = l_rowid_tab(i);
1023:
1024: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;