APPS.PA_EVENT_CORE dependencies on PA_ORGANIZATIONS_EVENT_V
Line 303: FROM pa_organizations_event_v
299: l_event_org_id NUMBER;
300:
301: CURSOR valid_event_org IS
302: SELECT organization_id 303: FROM pa_organizations_event_v 304: WHERE name=P_event_org_name
305: AND TRUNC(SYSDATE) BETWEEN date_from AND nvl(date_to, TRUNC(SYSDATE));
306:
307: BEGIN