APPS.AHL_UC_TREE_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 242: FROM ahl_mc_config_relations

238: x_uc_child_tbl(j).leaf_node_flag := 'N';
239: ELSE
240: x_uc_child_tbl(j).leaf_node_flag := 'Y';
241: SELECT count(mc_header_id) INTO l_children_no
242: FROM ahl_mc_config_relations
243: WHERE relationship_id = x_uc_child_tbl(j).relationship_id;
244: IF l_children_no > 0 THEN
245: x_uc_child_tbl(j).has_subconfig_flag := 'Y';
246: ELSE

Line 508: FROM ahl_mc_config_relations

504: -- rbhavsar:: FP Bug# 6268202, performance tuning
505: -- check if the MC has sub MCs or not
506: CURSOR has_sub_mc_csr(c_relationship_id NUMBER) IS
507: SELECT 'X'
508: FROM ahl_mc_config_relations
509: WHERE relationship_id = c_relationship_id
510: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
511: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
512: AND rownum = 1;

Line 1275: FROM ahl_mc_config_relations

1271: l_check_sub_uc check_sub_uc%ROWTYPE;
1272: --Given a position(leaf) in MC, get all the sub MCs which can be associated to this position
1273: CURSOR get_sub_mcs(c_relationship_id NUMBER) IS
1274: SELECT mc_header_id
1275: FROM ahl_mc_config_relations
1276: WHERE relationship_id = c_relationship_id
1277: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1278: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1279: --Based on the UC, list all of the non leaf nodes including the root node

Line 2045: FROM ahl_mc_config_relations

2041: l_check_sub_uc check_sub_uc%ROWTYPE;
2042: --Given a position(leaf) in MC, get all the sub MCs which can be associated to this position
2043: CURSOR get_sub_mcs(c_relationship_id NUMBER) IS
2044: SELECT mc_header_id
2045: FROM ahl_mc_config_relations
2046: WHERE relationship_id = c_relationship_id
2047: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2048: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2049: --Based on the UC, list all of the non leaf nodes including the root node