APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORGANIZATIONS_PROJECT_V

Line 924: FROM pa_organizations_project_v

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

Line 962: FROM pa_organizations_project_v

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