DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 118: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;

114: l_org_id NUMBER;
115: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;
116: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
117: l_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
118: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;
119: l_sysdate date:=sysdate;
120: l_ref_sufix NUMBER;
121:
122: l_project_number varchar2(25);

Line 175: FROM pa_expenditure_items_all item,

171: item.po_line_id,
172: item.inventory_item_id,
173: item.document_type,
174: item.document_distribution_type
175: FROM pa_expenditure_items_all item,
176: pa_cost_distribution_lines_all dist,
177: pa_expenditures_all exp
178: WHERE item.transaction_source IN ('CSE_PO_RECEIPT','CSE_INV_ISSUE')
179: AND item.project_id = p_in_srv_pa_attr_rec.project_id