DBA Data[Home] [Help]

APPS.AHL_UC_UNITCONFIG_PVT dependencies on AHL_MC_HEADERS_B

Line 325: FROM ahl_mc_headers_b H,

321: l_relationship_id NUMBER;
322: CURSOR get_rec_from_value(c_mc_name varchar2, c_mc_revision varchar2) IS
323: SELECT H.mc_header_id,
324: R.relationship_id
325: FROM ahl_mc_headers_b H,
326: ahl_mc_relationships R
327: WHERE H.name = c_mc_name
328: AND H.revision = c_mc_revision
329: AND H.mc_header_id = R.mc_header_id

Line 336: FROM ahl_mc_headers_b H,

332: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
333: CURSOR get_rec_from_id(c_mc_header_id NUMBER ) IS
334: SELECT H.mc_header_id,
335: R.relationship_id
336: FROM ahl_mc_headers_b H,
337: ahl_mc_relationships R
338: WHERE H.mc_header_id = c_mc_header_id
339: AND H.mc_header_id = R.mc_header_id
340: AND R.parent_relationship_id IS NULL