APPS.HZ_PERSON_CUST_BO_PUB dependencies on HZ_BUS_OBJ_TRACKING_S

Line 103: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

99: p_obj_complete_flag => l_valid_obj );
100:
101: IF(l_raise_event) THEN
102: -- Get event_id for person
103: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
104: INTO l_per_event_id
105: FROM DUAL;
106:
107: -- Get event_id for person customer

Line 108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

104: INTO l_per_event_id
105: FROM DUAL;
106:
107: -- Get event_id for person customer
108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
109: INTO l_pc_event_id
110: FROM DUAL;
111: END IF;
112: ELSE

Line 444: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

440: );
441:
442: IF(l_per_raise_event) THEN
443: -- Get event_id for person
444: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
445: INTO l_per_event_id
446: FROM DUAL;
447: END IF;
448:

Line 451: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

447: END IF;
448:
449: IF(l_pc_raise_event) THEN
450: -- Get event_id for person customer
451: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
452: INTO l_pc_event_id
453: FROM DUAL;
454: END IF;
455:

Line 2086: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

2082: p_obj_complete_flag => l_valid_obj );
2083:
2084: IF(l_raise_event) THEN
2085: -- Get event_id for person
2086: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2087: INTO l_per_event_id
2088: FROM DUAL;
2089:
2090: -- Get event_id for person customer

Line 2091: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

2087: INTO l_per_event_id
2088: FROM DUAL;
2089:
2090: -- Get event_id for person customer
2091: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2092: INTO l_pc_event_id
2093: FROM DUAL;
2094: END IF;
2095: ELSE

Line 2402: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

2398: );
2399:
2400: IF(l_per_raise_event) THEN
2401: -- Get event_id for person
2402: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2403: INTO l_per_event_id
2404: FROM DUAL;
2405: END IF;
2406:

Line 2409: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

2405: END IF;
2406:
2407: IF(l_pc_raise_event) THEN
2408: -- Get event_id for person customer
2409: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2410: INTO l_pc_event_id
2411: FROM DUAL;
2412: END IF;
2413: