DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on PA_TASKS

Line 880: SELECT COMPLETION_DATE from pa_tasks

876: l_category_seg2 VARCHAR2(40) := NULL;
877: l_charge_acct_id NUMBER := NULL;
878:
879: CURSOR get_prj_task_comp_date_csr (c_task_id IN NUMBER) IS
880: SELECT COMPLETION_DATE from pa_tasks
881: where task_id = c_task_id;
882:
883: l_task_completion_date DATE;
884: l_expenditure_item_type pa_expenditure_types.expenditure_type%type;