DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_BO_PUB dependencies on DUAL

Line 1551: FROM DUAL;

1547: -- get event_id and set global variable to event_id for
1548: -- BOT populate function
1549: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1550: INTO l_event_id
1551: FROM DUAL;
1552: END IF;
1553: ELSE
1554: l_raise_event := FALSE;
1555: END IF;

Line 2693: FROM DUAL;

2689: IF(l_org_raise_event) THEN
2690: -- Get event_id for org
2691: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2692: INTO l_org_event_id
2693: FROM DUAL;
2694: END IF;
2695:
2696: IF(l_oc_raise_event) THEN
2697: -- Get event_id for org customer

Line 2700: FROM DUAL;

2696: IF(l_oc_raise_event) THEN
2697: -- Get event_id for org customer
2698: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2699: INTO l_oc_event_id
2700: FROM DUAL;
2701: END IF;
2702: END IF;
2703:
2704: OPEN get_ovn(x_organization_id);