APPS.CSE_DEPLOYMENT_GRP dependencies on PA_EXPENDITURES_ALL

Line 522: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;

518: l_proj_itm_trf_qty NUMBER;
519: l_hz_location_id NUMBER;
520: i PLS_INTEGER := 0;
521: l_org_id NUMBER;
522: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;
523: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
524: l_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
525: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;
526: l_sysdate DATE:=sysdate;

Line 578: pa_expenditures_all exp

574: exp.expenditure_ending_date,
575: exp.incurred_by_organization_id
576: FROM pa_expenditure_items_all item,
577: pa_cost_distribution_lines_all dist,
578: pa_expenditures_all exp
579: WHERE item.transaction_source IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
580: AND item.project_id = p_trf_pa_attr_rec.project_id
581: AND item.task_id = p_trf_pa_attr_rec.task_id
582: AND item.attribute8 IS null