DBA Data[Home] [Help]

APPS.HZ_PERSON_BO_PUB dependencies on DUAL

Line 749: FROM DUAL;

745: -- get event_id and set global variable to event_id for
746: -- BOT populate function
747: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
748: INTO l_event_id
749: FROM DUAL;
750: END IF;
751: ELSE
752: l_raise_event := FALSE;
753: END IF;

Line 1342: FROM DUAL;

1338: IF(l_per_raise_event) THEN
1339: -- Get event_id for person
1340: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1341: INTO l_per_event_id
1342: FROM DUAL;
1343: END IF;
1344:
1345: IF(l_pc_raise_event) THEN
1346: -- Get event_id for person customer

Line 1349: FROM DUAL;

1345: IF(l_pc_raise_event) THEN
1346: -- Get event_id for person customer
1347: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1348: INTO l_pc_event_id
1349: FROM DUAL;
1350: END IF;
1351: END IF;
1352:
1353: OPEN get_ovn(x_person_id);