DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 4259: FROM pa_organizations_project_v

4255:
4256: CURSOR l_get_org_csr (p_organization_id NUMBER )
4257: IS
4258: SELECT 1
4259: FROM pa_organizations_project_v
4260: WHERE organization_id = p_organization_id
4261: AND active_flag = 'Y'
4262: AND TRUNC(SYSDATE) BETWEEN
4263: TRUNC(date_from) AND NVL(date_to, TRUNC(SYSDATE));