DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 4456: FROM pa_organizations_project_v

4452:
4453: CURSOR l_get_org_csr (p_organization_id NUMBER )
4454: IS
4455: SELECT 1
4456: FROM pa_organizations_project_v
4457: WHERE organization_id = p_organization_id
4458: AND active_flag = 'Y'
4459: AND TRUNC(SYSDATE) BETWEEN
4460: TRUNC(date_from) AND NVL(date_to, TRUNC(SYSDATE));