DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 925: FROM pa_organizations_project_v

921:
922: BEGIN
923: SELECT 1
924: INTO l_active_organization
925: FROM pa_organizations_project_v
926: WHERE organization_id = l_organization_id
927: AND active_flag = 'Y'
928: AND TRUNC(SYSDATE) BETWEEN TRUNC(date_from)
929: AND NVL(date_to, TRUNC(SYSDATE));

Line 963: FROM pa_organizations_project_v

959:
960: BEGIN
961: SELECT 1
962: INTO l_active_organization
963: FROM pa_organizations_project_v
964: WHERE organization_id = l_organization_id
965: AND active_flag = 'Y'
966: AND TRUNC(SYSDATE) BETWEEN TRUNC(date_from)
967: AND NVL(date_to, TRUNC(SYSDATE));