APPS.HZ_ORGANIZATION_BO_PUB dependencies on DUAL

Line 1522: FROM DUAL;

1518: -- get event_id and set global variable to event_id for
1519: -- BOT populate function
1520: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1521: INTO l_event_id
1522: FROM DUAL;
1523: END IF;
1524: ELSE
1525: l_raise_event := FALSE;
1526: END IF;

Line 2150: FROM DUAL;

2146: IF(l_org_raise_event) THEN
2147: -- Get event_id for org
2148: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2149: INTO l_org_event_id
2150: FROM DUAL;
2151: END IF;
2152:
2153: IF(l_oc_raise_event) THEN
2154: -- Get event_id for org customer

Line 2157: FROM DUAL;

2153: IF(l_oc_raise_event) THEN
2154: -- Get event_id for org customer
2155: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2156: INTO l_oc_event_id
2157: FROM DUAL;
2158: END IF;
2159: END IF;
2160:
2161: OPEN get_ovn(x_organization_id);