APPS.PA_PURGE_COSTING dependencies on PA_MC_CC_DIST_LINES_AR

Line 821: from pa_mc_cc_dist_lines_ar cdar

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 ) ;
823: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT;
824: End if;
825:

Line 872: /* 'PA_MC_CC_DIST_LINES_AR', */

868: l_NoOfRecordsDel,
869: x_err_code,
870: x_err_stack,
871: x_err_stage,
872: /* 'PA_MC_CC_DIST_LINES_AR', */
873: 'PA_MC_CC_DIST_LINES',
874: x_MRC_NoOfRecordsIns,
875: l_MRC_NoOfRecordsDel
876: ) ;

Line 4381: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;

4377: BEGIN
4378:
4379: l_old_err_stack := x_err_stack;
4380:
4381: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4382:
4383: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4384: INSERT INTO PA_MC_CC_DIST_LINES_AR
4385: (PURGE_BATCH_ID,

Line 4383: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;

4379: l_old_err_stack := x_err_stack;
4380:
4381: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4382:
4383: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4384: INSERT INTO PA_MC_CC_DIST_LINES_AR
4385: (PURGE_BATCH_ID,
4386: PURGE_RELEASE,
4387: PURGE_PROJECT_ID,

Line 4384: INSERT INTO PA_MC_CC_DIST_LINES_AR

4380:
4381: x_err_stack := x_err_stack || ' ->Before insert into MRC PA_MC_CC_DIST_LINES_AR ' ;
4382:
4383: x_err_stage := 'Before insert into PA_MC_CC_DIST_LINES_AR' ;
4384: INSERT INTO PA_MC_CC_DIST_LINES_AR
4385: (PURGE_BATCH_ID,
4386: PURGE_RELEASE,
4387: PURGE_PROJECT_ID,
4388: SET_OF_BOOKS_ID,

Line 4440: PA_MC_CC_DIST_LINES_AR MC_AR_CDL

4436: AND AR_CDL.PURGE_PROJECT_ID = P_PROJECT_ID
4437: AND NOT EXISTS (
4438: SELECT MC_CDL.expenditure_item_id
4439: FROM
4440: PA_MC_CC_DIST_LINES_AR MC_AR_CDL
4441: WHERE
4442: MC_AR_CDL.purge_project_id = P_PROJECT_ID
4443: AND MC_AR_CDL.expenditure_item_id = MC_CDL.expenditure_item_id
4444: AND MC_AR_CDL.line_num = MC_CDL.line_num