DBA Data[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'