DBA Data[Home] [Help]

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