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 892: FROM HZ_BUS_OBJ_TRACKING

888: CHILD_BO_CODE,
889: CHILD_ENTITY_NAME,
890: CHILD_ID,
891: populated_flag
892: FROM HZ_BUS_OBJ_TRACKING
893: where event_id = p_event_id
894: START WITH child_id = p_root_id
895: AND child_entity_name = 'HZ_PARTIES'
896: AND PARENT_BO_CODE IS NULL

Line 906: FROM HZ_BUS_OBJ_TRACKING

902: and event_id = PRIOR event_id;
903:
904: cursor c2 is
905: select child_event_id,creation_date
906: FROM HZ_BUS_OBJ_TRACKING
907: where event_id = p_event_id
908: and parent_bo_code is null
909: and rownum = 1;
910:

Line 914: FROM HZ_BUS_OBJ_TRACKING

910:
911: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
912:
913: SELECT event_id
914: FROM HZ_BUS_OBJ_TRACKING
915: WHERE creation_date = cp_creation_date
916: AND child_id = p_root_id
917: AND child_event_id IS NULL
918: and event_id <> p_event_id

Line 2038: FROM HZ_BUS_OBJ_TRACKING

2034: CHILD_BO_CODE,
2035: CHILD_ENTITY_NAME,
2036: CHILD_ID,
2037: populated_flag
2038: FROM HZ_BUS_OBJ_TRACKING
2039: where event_id = p_event_id
2040: START WITH child_id = p_root_id
2041: AND child_entity_name = 'HZ_PARTIES'
2042: AND PARENT_BO_CODE IS NULL

Line 2052: FROM HZ_BUS_OBJ_TRACKING

2048: and event_id = PRIOR event_id;
2049:
2050: cursor c2 is
2051: select child_event_id,creation_date
2052: FROM HZ_BUS_OBJ_TRACKING
2053: where event_id = p_event_id
2054: and parent_bo_code is null
2055: and rownum = 1;
2056:

Line 2060: FROM HZ_BUS_OBJ_TRACKING

2056:
2057: CURSOR c_get_child_event_id(cp_creation_date DATE) IS
2058:
2059: SELECT event_id
2060: FROM HZ_BUS_OBJ_TRACKING
2061: WHERE creation_date = cp_creation_date
2062: AND child_id = p_root_id
2063: AND child_event_id IS NULL
2064: and event_id <> p_event_id