APPS.CN_SFP_ROLE_UTIL_PVT dependencies on CN_SEAS_SCHEDULES_ALL

Line 55: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_SEAS_SCHEDULES_ALL WHERE SEAS_SCHEDULE_ID = l_seas_id;

51: END IF;
52: END IF;
53:
54: IF l_seas_id IS NOT NULL THEN
55: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_SEAS_SCHEDULES_ALL WHERE SEAS_SCHEDULE_ID = l_seas_id;
56: IF l_temp_org <> l_org_id THEN
57: l_seas_pass := 'N';
58: EXIT;
59: END IF;