DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 446: FROM pa_expenditure_items_all pei

442: pei.attribute7 attribute7,
443: pei.attribute8 attribute8,
444: pei.attribute9 attribute9,
445: pei.attribute10 attribute10
446: FROM pa_expenditure_items_all pei
447: WHERE pei.project_id = p_project_id
448: AND pei.task_Id = p_task_id
449: AND pei.transaction_source IN ('CSE_PO_RECEIPT', 'CSE_INV_ISSUE')
450: AND substr(pei.orig_transaction_reference,1,

Line 861: UPDATE pa_expenditure_items_all

857: x_processed_flag := 'Y';
858:
859: END IF;
860:
861: UPDATE pa_expenditure_items_all
862: SET crl_asset_creation_status_code = 'Y'
863: WHERE expenditure_item_id = exp_line_rec.expenditure_item_id;
864:
865: END LOOP;