APPS.AHL_PC_NODE_PVT dependencies on AHL_PC_ASSOCIATIONS

Line 483: FROM ahl_pc_associations ahass

479: ORDER BY pc_node_id DESC;
480:
481: SELECT pc_association_id
482: BULK COLLECT INTO l_assos_tbl
483: FROM ahl_pc_associations ahass
484: WHERE pc_node_id IN
485: (
486: SELECT pc_node_id
487: FROM ahl_pc_nodes_b

Line 601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

597: BEGIN
598:
599: SELECT distinct 'X'
600: INTO l_exist
601: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
602: WHERE uf.unit_config_header_id = assos.unit_item_id and
603: assos.pc_node_id = node.pc_node_id and
604: node.pc_node_id IN (
605: SELECT pc_node_id

Line 625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node

621: BEGIN
622:
623: SELECT distinct 'X'
624: INTO l_exist
625: FROM ahl_utilization_forecast_v uf, ahl_pc_associations assos, ahl_pc_nodes_b node
626: WHERE uf.inventory_item_id = assos.unit_item_id and
627: uf.inventory_org_id = assos.inventory_org_id and
628: assos.pc_node_id = node.pc_node_id and
629: node.pc_node_id IN (

Line 698: FROM ahl_pc_associations

694:
695: FOR i IN l_assos_tbl.FIRST..l_assos_tbl.LAST
696: LOOP
697: DELETE
698: FROM ahl_pc_associations
699: WHERE pc_association_id = l_assos_tbl(i);
700: END LOOP;
701: END IF;
702:

Line 941: from ahl_pc_nodes_b node, ahl_pc_associations ahass

937:
938: CURSOR check_leaf_node (p_parent_node_id IN NUMBER)
939: IS
940: select 'X'
941: from ahl_pc_nodes_b node, ahl_pc_associations ahass
942: where node.pc_node_id = p_parent_node_id and
943: ahass.pc_node_id = p_parent_node_id;
944:
945: BEGIN