DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_UPG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 953: ar_payment_schedules_all psch,

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

Line 1018: UPDATE ar_payment_schedules_all

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