APPS.PA_PURGE_CAPITAL dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 126: PA_Expenditure_Items_All pei ,

122: pmald.Currency_Code,
123: pmald.Exchange_Rate,
124: pmald.Conversion_Date
125: FROM
126: PA_Expenditure_Items_All pei ,
127: PA_Project_Asset_Line_Details pald,
128: pa_implementations_all pia ,
129: -- gl_mc_reporting_options gmc ,
130: GL_ALC_LEDGER_RSHIPS_V gmc, -- R12 Ledger changes

Line 336: PA_Expenditure_Items_All pei

332: p_project_id
333: FROM
334: PA_MC_Prj_Ast_Line_Dtls pmald,
335: PA_Project_Asset_Line_Details pald,
336: PA_Expenditure_Items_All pei
337: WHERE
338: pald.proj_asset_line_dtl_uniq_id = pmald.proj_asset_line_dtl_uniq_id
339: AND pald.Expenditure_Item_id = pei.Expenditure_Item_id
340: AND pei.project_id = p_project_id

Line 358: PA_Expenditure_Items_All pei

354: WHERE (pmald.Proj_Asset_Line_Dtl_Uniq_Id) in
355: ( SELECT pmaldar.Proj_Asset_Line_Dtl_Uniq_Id
356: FROM PA_MC_PRJ_AST_LN_DET_AR pmaldar,
357: PA_Project_Asset_Line_Details pald,
358: PA_Expenditure_Items_All pei
359: WHERE
360: pald.Proj_Asset_Line_Dtl_Uniq_Id =
361: pmaldar.Proj_Asset_Line_Dtl_Uniq_Id
362: AND pald.Expenditure_Item_id = pei.Expenditure_Item_id

Line 382: PA_Expenditure_Items_All pei

378: DELETE FROM PA_MC_Prj_Ast_line_Dtls pmald
379: WHERE Exists ---- Bug 3613739 proj_asset_line_dtl_uniq_id IN
380: (SELECT proj_asset_line_dtl_uniq_id
381: FROM PA_Project_Asset_Line_Details pald,
382: PA_Expenditure_Items_All pei
383: WHERE pald.Expenditure_Item_id = pei.Expenditure_Item_id
384: AND pmald.proj_asset_line_dtl_uniq_id = pald.proj_asset_line_dtl_uniq_id -- Bug 3613739
385: AND pei.project_id = p_project_id)
386: AND rownum < l_commit_size ;

Line 513: PA_Expenditure_Items_All pei

509: p_project_id,
510: pald.PROJ_ASSET_LINE_DTL_UNIQ_ID /* Bug#2385541 */
511: FROM
512: PA_Project_Asset_Line_Details pald,
513: PA_Expenditure_Items_All pei
514: WHERE
515: pald.Expenditure_Item_id = pei.Expenditure_Item_id
516: AND pei.project_id = p_project_id
517: AND rownum < l_commit_size ;

Line 537: PA_Expenditure_Items_All pei

533: WHERE (pald.Project_Asset_Line_Detail_Id) IN
534: ( SELECT pald1.Proj_Asset_Line_Dtl_Uniq_Id
535: FROM PA_Project_Asset_line_Details pald1,
536: PA_PRJ_ASSET_LN_DETS_AR paldar,
537: PA_Expenditure_Items_All pei
538: WHERE
539: pald1.Project_Asset_Line_Detail_Id = paldar.Project_Asset_Line_Detail_Id
540: AND paldar.Expenditure_Item_Id = pei.Expenditure_Item_Id
541: and pei.project_id = p_project_id ) ;

Line 569: FROM PA_Expenditure_Items_All pei

565: l_err_stage := 'Before Deleting from PA_Project_Asset_line_Details table ';
566:
567: DELETE FROM PA_Project_Asset_line_Details pald
568: WHERE Expenditure_Item_Id in (SELECT pei.Expenditure_Item_Id
569: FROM PA_Expenditure_Items_All pei
570: WHERE pei.project_id = p_project_id)
571: AND rownum < l_commit_size ;
572: /* Commented for the Bug#2385541
573: NoOfRecordsDel := nvl(NoOfRecordsDel, 0) + SQL%ROWCOUNT ; */