APPS.AHL_MC_PATH_POSITION_PUB dependencies on AHL_MC_HEADERS_B

Line 180: FROM AHL_MC_HEADERS_B

176: ) IS
177:
178: CURSOR chk_mc_id_csr (p_mc_id NUMBER) IS
179: SELECT 'X'
180: FROM AHL_MC_HEADERS_B
181: WHERE mc_id = p_mc_id;
182:
183: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2) IS
184: SELECT mc_id

Line 185: FROM AHL_MC_HEADERS_B

181: WHERE mc_id = p_mc_id;
182:
183: CURSOR chk_mc_name_csr (p_mc_name VARCHAR2) IS
184: SELECT mc_id
185: FROM AHL_MC_HEADERS_B
186: WHERE name = p_mc_name;
187:
188: CURSOR chk_mc_ver_no_csr (p_mc_id NUMBER, p_ver_no NUMBER) IS
189: SELECT 'X'

Line 190: FROM AHL_MC_HEADERS_B

186: WHERE name = p_mc_name;
187:
188: CURSOR chk_mc_ver_no_csr (p_mc_id NUMBER, p_ver_no NUMBER) IS
189: SELECT 'X'
190: FROM AHL_MC_HEADERS_B
191: WHERE version_number = p_ver_no
192: AND mc_id = p_mc_id;
193:
194: CURSOR chk_mc_revision_csr (p_mc_id NUMBER, p_revision VARCHAR2) IS

Line 196: FROM AHL_MC_HEADERS_B

192: AND mc_id = p_mc_id;
193:
194: CURSOR chk_mc_revision_csr (p_mc_id NUMBER, p_revision VARCHAR2) IS
195: SELECT version_number
196: FROM AHL_MC_HEADERS_B
197: WHERE revision = p_revision
198: AND mc_id = p_mc_id;
199: --
200: l_api_name CONSTANT VARCHAR2(30) := 'Convert_Path_Pos_Values_to_Id';