DBA Data[Home] [Help]

APPS.HZ_PERSON_BO_PUB dependencies on DUAL

Line 778: FROM DUAL;

774: -- get event_id and set global variable to event_id for
775: -- BOT populate function
776: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
777: INTO l_event_id
778: FROM DUAL;
779: END IF;
780: ELSE
781: l_raise_event := FALSE;
782: END IF;

Line 1771: FROM DUAL;

1767: IF(l_per_raise_event) THEN
1768: -- Get event_id for person
1769: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1770: INTO l_per_event_id
1771: FROM DUAL;
1772: END IF;
1773:
1774: IF(l_pc_raise_event) THEN
1775: -- Get event_id for person customer

Line 1778: FROM DUAL;

1774: IF(l_pc_raise_event) THEN
1775: -- Get event_id for person customer
1776: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1777: INTO l_pc_event_id
1778: FROM DUAL;
1779: END IF;
1780: END IF;
1781:
1782: OPEN get_ovn(x_person_id);