1782: --PRAKKUM ::FP PIE :: 13-OCT-2010
1783: --To validate that the project completion is in future
1784: Cursor validate_proj_date_csr ( c_project_id IN NUMBER)
1785: IS
1786: SELECT 'X' from PA_PROJECTS_EXPEND_V
1787: WHERE project_id = c_project_id
1788: AND NVL(completion_date,SYSDATE+1)>=SYSDATE;
1789: /*Added by sowsubra*/
1790: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
3463: --PRAKKUM ::FP PIE :: 13-OCT-2010
3464: --To validate that the project completion is in future
3465: Cursor validate_proj_date_csr ( c_project_id IN NUMBER)
3466: IS
3467: SELECT 'X' from PA_PROJECTS_EXPEND_V
3468: WHERE project_id = c_project_id
3469: AND NVL(completion_date,SYSDATE+1)>=SYSDATE;
3470:
3471: /*Added by sowsubra*/