DBA Data[Home] [Help]

APPS.PA_REP_UTIL_SETUP dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 27: ,pa_cost_distribution_lines_all cdl

23:
24: CURSOR discarded_records(p_cut_off_date IN DATE) IS
25: select cdl.rowid
26: from pa_expenditure_items_all ei
27: ,pa_cost_distribution_lines_all cdl
28: where ei.expenditure_item_date < p_cut_off_date
29: and ei.expenditure_item_id = cdl.expenditure_item_id;
30:
31:

Line 110: UPDATE pa_cost_distribution_lines_all cdl

106: END IF;
107:
108: for rec in discarded_records(l_cut_off_date)
109: LOOP
110: UPDATE pa_cost_distribution_lines_all cdl
111: SET cdl.util_summarized_flag = 'X'
112: WHERE rowid = rec.rowid;
113:
114: l_records_update := l_records_update + 1;