APPS.PA_PURGE_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 237: from pa_cost_distribution_lines_all cdl,

233: exp_ind NUMBER;
234: l_fetch_complete BOOLEAN := FALSE;
235: cursor cdl_open_projects is
236: select cdl.rowid
237: from pa_cost_distribution_lines_all cdl,
238: pa_expenditure_items_all ei
239: where cdl.expenditure_item_id = ei.expenditure_item_id
240: and ei.expenditure_item_date <= p_txn_to_date
241: and ei.project_id = p_project_id;

Line 245: from pa_cost_distribution_lines_all cdl

241: and ei.project_id = p_project_id;
242:
243: cursor cdl_close_projects is
244: select cdl.rowid
245: from pa_cost_distribution_lines_all cdl
246: where cdl.project_id = p_project_id;
247:
248: begin
249:

Line 467: from pa_cost_distribution_lines_all cdl

463: ,cdl.si_assets_addition_flag -- R12 change
464: ,cdl.system_reference5 -- R12 change
465: ,cdl.acct_event_id -- R12 change
466: ,cdl.acct_source_code -- R12 change
467: from pa_cost_distribution_lines_all cdl
468: where cdl.rowid = l_cdl_rowid_tab(exp_ind);
469:
470: l_NoOfRecordsIns := SQL%ROWCOUNT ;
471:

Line 505: x_err_stage := 'Before deleting records from pa_cost_distribution_lines_all' ;

501: */
502: IF (l_mrc_flag = 'Y') THEN
503: pa_utils2.MRC_row_count := 0;
504: END IF;
505: x_err_stage := 'Before deleting records from pa_cost_distribution_lines_all' ;
506: FORALL exp_ind in l_cdl_rowid_tab.FIRST .. l_cdl_rowid_tab.LAST
507: DELETE FROM PA_COST_DISTRIBUTION_LINES_ALL cdl
508: WHERE CDL.rowid = l_cdl_rowid_tab(exp_ind);
509:

Line 507: DELETE FROM PA_COST_DISTRIBUTION_LINES_ALL cdl

503: pa_utils2.MRC_row_count := 0;
504: END IF;
505: x_err_stage := 'Before deleting records from pa_cost_distribution_lines_all' ;
506: FORALL exp_ind in l_cdl_rowid_tab.FIRST .. l_cdl_rowid_tab.LAST
507: DELETE FROM PA_COST_DISTRIBUTION_LINES_ALL cdl
508: WHERE CDL.rowid = l_cdl_rowid_tab(exp_ind);
509:
510: l_NoOfRecordsDel := SQL%ROWCOUNT;
511: l_MRC_NoOfRecordsDel := pa_utils2.MRC_row_count ;