APPS.AHL_UC_TREE_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 231: FROM ahl_mc_config_relations

227: x_uc_child_tbl(j).leaf_node_flag := 'N';
228: ELSE
229: x_uc_child_tbl(j).leaf_node_flag := 'Y';
230: SELECT count(mc_header_id) INTO l_children_no
231: FROM ahl_mc_config_relations
232: WHERE relationship_id = x_uc_child_tbl(j).relationship_id;
233: IF l_children_no > 0 THEN
234: x_uc_child_tbl(j).has_subconfig_flag := 'Y';
235: ELSE

Line 494: FROM ahl_mc_config_relations

490: -- rbhavsar:: FP Bug# 6268202, performance tuning
491: -- check if the MC has sub MCs or not
492: CURSOR has_sub_mc_csr(c_relationship_id NUMBER) IS
493: SELECT 'X'
494: FROM ahl_mc_config_relations
495: WHERE relationship_id = c_relationship_id
496: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
497: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
498: AND rownum = 1;

Line 1233: FROM ahl_mc_config_relations

1229: l_check_sub_uc check_sub_uc%ROWTYPE;
1230: --Given a position(leaf) in MC, get all the sub MCs which can be associated to this position
1231: CURSOR get_sub_mcs(c_relationship_id NUMBER) IS
1232: SELECT mc_header_id
1233: FROM ahl_mc_config_relations
1234: WHERE relationship_id = c_relationship_id
1235: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1236: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1237: --Based on the UC, list all of the non leaf nodes including the root node

Line 1982: FROM ahl_mc_config_relations

1978: l_check_sub_uc check_sub_uc%ROWTYPE;
1979: --Given a position(leaf) in MC, get all the sub MCs which can be associated to this position
1980: CURSOR get_sub_mcs(c_relationship_id NUMBER) IS
1981: SELECT mc_header_id
1982: FROM ahl_mc_config_relations
1983: WHERE relationship_id = c_relationship_id
1984: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1985: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1986: --Based on the UC, list all of the non leaf nodes including the root node