APPS.PA_PURGE_COSTING dependencies on PA_MC_CC_DIST_LINES_ALL

Line 817: x_err_stage := 'Before deleting records from PA_MC_CC_DIST_LINES_ALL' ;

813: pa_utils2.MRC_row_count := 0;
814: END IF;
815:
816: If ( p_archive_flag = 'Y' and x_MRC_NoOfRecordsIns > 0 )Then
817: x_err_stage := 'Before deleting records from PA_MC_CC_DIST_LINES_ALL' ;
818: delete from pa_mc_cc_dist_lines_all cdl
819: where (cdl.cc_dist_line_id) in
820: ( select cdar.cc_dist_line_id
821: from pa_mc_cc_dist_lines_ar cdar

Line 818: delete from pa_mc_cc_dist_lines_all cdl

814: END IF;
815:
816: If ( p_archive_flag = 'Y' and x_MRC_NoOfRecordsIns > 0 )Then
817: x_err_stage := 'Before deleting records from PA_MC_CC_DIST_LINES_ALL' ;
818: delete from pa_mc_cc_dist_lines_all cdl
819: where (cdl.cc_dist_line_id) in
820: ( select cdar.cc_dist_line_id
821: from pa_mc_cc_dist_lines_ar cdar
822: where cdar.purge_project_id = p_project_id ) ;

Line 827: delete from pa_mc_cc_dist_lines_all cdl

823: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT;
824: End if;
825:
826: If ( l_mrc_flag = 'Y' and p_archive_flag <> 'Y' )Then
827: delete from pa_mc_cc_dist_lines_all cdl
828: where cdl.rowid in
829: ( select cdl1.rowid
830: from pa_expenditure_items_all ei,
831: pa_mc_cc_dist_lines_all cdl1

Line 831: pa_mc_cc_dist_lines_all cdl1

827: delete from pa_mc_cc_dist_lines_all cdl
828: where cdl.rowid in
829: ( select cdl1.rowid
830: from pa_expenditure_items_all ei,
831: pa_mc_cc_dist_lines_all cdl1
832: where cdl1.expenditure_item_id = ei.expenditure_item_id
833: and ei.project_id = p_project_id
834: and rownum < l_commit_size
835: ) ;

Line 4435: PA_MC_CC_DIST_LINES_ALL MC_CDL,

4431: MC_CDL.GL_BATCH_NAME,
4432: MC_CDL.TRANSFERRED_DATE,
4433: MC_CDL.TRANSFER_REJECTION_CODE
4434: FROM
4435: PA_MC_CC_DIST_LINES_ALL MC_CDL,
4436: PA_CC_DIST_LINES_AR AR_CDL
4437: WHERE
4438: MC_CDL.EXPENDITURE_ITEM_ID = AR_CDL.EXPENDITURE_ITEM_ID
4439: AND MC_CDL.LINE_NUM = AR_CDL.LINE_NUM