DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 433: FROM pa_expenditure_items_all pei

429: pei.attribute7 attribute7,
430: pei.attribute8 attribute8,
431: pei.attribute9 attribute9,
432: pei.attribute10 attribute10
433: FROM pa_expenditure_items_all pei
434: WHERE pei.project_id = p_project_id
435: AND pei.task_Id = p_task_id
436: AND pei.transaction_source IN ('CSE_PO_RECEIPT', 'CSE_INV_ISSUE')
437: AND substr(pei.orig_transaction_reference,1,

Line 847: UPDATE pa_expenditure_items_all

843: x_processed_flag := 'Y';
844:
845: END IF;
846:
847: UPDATE pa_expenditure_items_all
848: SET crl_asset_creation_status_code = 'Y'
849: WHERE expenditure_item_id = exp_line_rec.expenditure_item_id;
850:
851: END LOOP;