APPS.AS_RTTAP_OPPTY dependencies on DUAL

Line 433: AND tm.resource_type = 'INDIVIDUAL'

429: AND tu.team_id = t.team_id
430: AND tu.usage IN ('SALES','PRM')
431: AND tm.team_member_id = trr.role_resource_id
432: AND tm.delete_flag <> 'Y'
433: AND tm.resource_type = 'INDIVIDUAL'
434: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
435: AND trr.delete_flag <> 'Y'
436: AND SYSDATE BETWEEN trr.start_date_active
437: AND NVL(trr.end_date_active,SYSDATE)

Line 971: FROM DUAL;

967: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'Before Calling BE Procedure ' || AS_GAR.G_START);
968:
969: SELECT l_event_name || AS_BUSINESS_EVENT_S.nextval
970: INTO x_event_key
971: FROM DUAL;
972:
973: AS_BUSINESS_EVENT_PVT.raise_event(
974: p_event_name => l_event_name,
975: p_event_key => x_event_key,