APPS.EGO_CATG_MAP_UTIL_PKG dependencies on EGO_CATG_MAP_HDRS_B

Line 31: FROM EGO_CATG_MAP_HDRS_B

27: CURSOR c_get_catalog_id(cp_catg_map_id NUMBER)
28: IS
29: SELECT
30: target_catg_set_id
31: FROM EGO_CATG_MAP_HDRS_B
32: WHERE catg_map_id = cp_catg_map_id;*/
33:
34:
35:

Line 41: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr

37: CURSOR c_get_acc_category_id(cp_category_id NUMBER)
38: IS
39: SELECT
40: target_catg_id,target_catg_set_id
41: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
42: WHERE det.catg_map_id = hdr.catg_map_id
43: AND source_catg_id = cp_category_id
44: AND ENABLED_FLAG = 'Y'
45: AND ROWNUM = 1;

Line 99: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr

95: CURSOR c_get_icc_category_id(cp_category_id NUMBER)
96: IS
97: SELECT
98: target_catg_id
99: FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
100: WHERE det.catg_map_id = hdr.catg_map_id
101: AND source_catg_id = cp_category_id
102: AND target_catg_set_id = -1
103: AND ENABLED_FLAG = 'Y'