DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on PA_PROJECTS_EXPEND_V

Line 1786: SELECT 'X' from PA_PROJECTS_EXPEND_V

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

Line 3467: SELECT 'X' from PA_PROJECTS_EXPEND_V

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*/