APPS.PA_MC_UPG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 116: FROM PA_EXPENDITURE_ITEMS_ALL EI,

112: Order BY Proj.Project_ID;
113: Cursor C_CC_EI
114: IS
115: SELECT EI.expenditure_item_id
116: FROM PA_EXPENDITURE_ITEMS_ALL EI,
117: PA_IMPLEMENTATIONS_ALL IMP1,
118: PA_IMPLEMENTATIONS_ALL IMP2
119: WHERE EI.ORG_ID = G_Org_ID
120: AND EI.ORG_ID <> EI.RECVR_ORG_ID

Line 225: from pa_expenditure_items_all pei

221:
222: /* Added UNION for fix of 3159188 */
223: CURSOR C_currency IS
224: (SELECT distinct denom_currency_code
225: from pa_expenditure_items_all pei
226: where not exists (select null
227: from PA_MC_UPGRADE_RATES
228: where From_currency = pei.denom_currency_code
229: and To_Currency = G_Rep_Curr_Code

Line 906: From PA_Expenditure_Items_ALL

902: acct_tp_rate_date,
903: acct_tp_exchange_rate,
904: denom_currency_code -- added for MRC enhancement
905: ,org_id
906: From PA_Expenditure_Items_ALL
907: Where expenditure_item_id < NVL(G_MIN_exp_item_id,G_MAX_exp_item_id)
908: And Project_Id = x_Project_ID;
909: /* Bug 3961113 : Removing unnecessary join with PA_TASKS
910: and Task_id IN ( Select task_id

Line 1264: PA_EXPENDITURE_ITEMS_ALL EI

1260: DINVDTLS.CC_TAX_TASK_ID CC_TAX_TASK_ID,
1261: EI.Expenditure_item_date EI_DATE
1262:
1263: FROM PA_DRAFT_INVOICE_DETAILS_ALL DINVDTLS,
1264: PA_EXPENDITURE_ITEMS_ALL EI
1265: WHERE DINVDTLS.project_id = G_Project_ID
1266: AND DINVDTLS.draft_invoice_detail_id <
1267: NVL(G_MIN_DRAFT_INV_DTL_ID,G_MAX_DRAFT_INV_DTL_ID)
1268: AND EI.expenditure_item_id = DINVDTLS.EXPENDITURE_ITEM_ID;

Line 1402: PA_EXPENDITURE_ITEMS_ALL EI

1398: 'Y', decode(sign(EI.expenditure_item_date - G_MRC_LED),-1 ,
1399: G_Fixed_Date, EI.expenditure_item_date)
1400: ) conversion_date
1401: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
1402: PA_EXPENDITURE_ITEMS_ALL EI
1403: WHERE CDL.expenditure_item_id = G_EI_Array(k)
1404: AND CDL.line_type <> 'I' -- burdening enhancements
1405: AND EI.expenditure_item_id = CDL.expenditure_item_id;
1406:

Line 1482: From PA_Expenditure_Items_ALL

1478: cc_cross_charge_code,
1479: project_exchange_rate,
1480: recvr_org_id
1481:
1482: From PA_Expenditure_Items_ALL
1483: Where expenditure_item_id = G_EI_Array(k);
1484:
1485: Begin
1486: v_Old_Stack := G_Err_Stack;