APPS.HZ_EXTRACT_ORG_CUST_BO_PVT dependencies on HZ_BUS_OBJ_TRACKING

Line 210: from hz_bus_obj_tracking

206:
207:
208: cursor check_org_action_type_csr is
209: select child_operation_flag
210: from hz_bus_obj_tracking
211: where event_id = p_event_id
212: and child_bo_code = 'ORG'
213: and parent_bo_code = 'ORG_CUST';
214:

Line 930: FROM HZ_BUS_OBJ_TRACKING

926: CHILD_BO_CODE,
927: CHILD_ENTITY_NAME,
928: CHILD_ID,
929: populated_flag
930: FROM HZ_BUS_OBJ_TRACKING
931: where event_id = p_event_id
932: START WITH child_id = p_root_id
933: AND child_entity_name = 'HZ_PARTIES'
934: AND PARENT_BO_CODE IS NULL

Line 944: FROM HZ_BUS_OBJ_TRACKING

940: and event_id = PRIOR event_id;
941:
942: cursor c2 is
943: select child_event_id,creation_date
944: FROM HZ_BUS_OBJ_TRACKING
945: where event_id = p_event_id
946: and parent_bo_code is null
947: and rownum = 1;
948:

Line 952: FROM HZ_BUS_OBJ_TRACKING

948:
949: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
950:
951: SELECT event_id
952: FROM HZ_BUS_OBJ_TRACKING
953: WHERE creation_date = cp_creation_date
954: AND child_id = p_root_id
955: AND child_event_id IS NULL
956: and event_id <> p_event_id

Line 2076: FROM HZ_BUS_OBJ_TRACKING

2072: CHILD_BO_CODE,
2073: CHILD_ENTITY_NAME,
2074: CHILD_ID,
2075: populated_flag
2076: FROM HZ_BUS_OBJ_TRACKING
2077: where event_id = p_event_id
2078: START WITH child_id = p_root_id
2079: AND child_entity_name = 'HZ_PARTIES'
2080: AND PARENT_BO_CODE IS NULL

Line 2090: FROM HZ_BUS_OBJ_TRACKING

2086: and event_id = PRIOR event_id;
2087:
2088: cursor c2 is
2089: select child_event_id,creation_date
2090: FROM HZ_BUS_OBJ_TRACKING
2091: where event_id = p_event_id
2092: and parent_bo_code is null
2093: and rownum = 1;
2094:

Line 2098: FROM HZ_BUS_OBJ_TRACKING

2094:
2095: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
2096:
2097: SELECT event_id
2098: FROM HZ_BUS_OBJ_TRACKING
2099: WHERE creation_date = cp_creation_date
2100: AND child_id = p_root_id
2101: AND child_event_id IS NULL
2102: and event_id <> p_event_id