[Home] [Help]
APPS.EGO_CATG_MAP_UTIL_PKG dependencies on EGO_CATG_MAP_HDRS_B
Line 27: FROM EGO_CATG_MAP_HDRS_B
23: CURSOR c_get_catalog_id(cp_catg_map_id NUMBER)
24: IS
25: SELECT
26: target_catg_set_id
27: FROM EGO_CATG_MAP_HDRS_B
28: WHERE catg_map_id = cp_catg_map_id;
29:
30: BEGIN
31:
Line 61: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
57: CURSOR c_get_icc_category_id(cp_category_id NUMBER)
58: IS
59: SELECT
60: target_catg_id
61: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
62: WHERE det.catg_map_id = hdr.catg_map_id
63: AND source_catg_id = cp_category_id
64: AND target_catg_set_id = -1
65: AND ENABLED_FLAG = 'Y'