APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_PC_NODES_B

Line 1867: FROM AHL_PC_NODES_B

1863: -- priyan : bug #5302804
1864: (
1865: -- traverse up the branch, for MEL/CDL, from the PC node being deleted
1866: SELECT PC_NODE_ID
1867: FROM AHL_PC_NODES_B
1868: CONNECT BY PRIOR PARENT_NODE_ID= PC_NODE_ID
1869: START WITH PC_NODE_ID = p_pc_node_id
1870: UNION
1871: -- traverse down the tree, for MEL/CDL, from the PC node being deleted

Line 1873: FROM AHL_PC_NODES_B

1869: START WITH PC_NODE_ID = p_pc_node_id
1870: UNION
1871: -- traverse down the tree, for MEL/CDL, from the PC node being deleted
1872: SELECT PC_NODE_ID
1873: FROM AHL_PC_NODES_B
1874: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID
1875: START WITH PC_NODE_ID = p_pc_node_id
1876: )
1877: AND ROWNUM = 1;

Line 1980: from ahl_pc_nodes_b pcn,

1976: )
1977: IS
1978: SELECT * FROM (
1979: select mel.mel_cdl_header_id, mel.version_number, pcn.pc_node_id
1980: from ahl_pc_nodes_b pcn,
1981: ahl_mel_cdl_headers mel
1982: where pcn.pc_node_id = mel.pc_node_id (+) and
1983: --where pcn.pc_node_id = mel.pc_node_id and -- fix for bug# 9775781. Need outer join else nodes with no MEL definition will not be skipped.
1984: mel.mel_cdl_type_code = l_mel_cdl_type_code and

Line 1992: ahl_pc_nodes_b node,

1988: start with pcn.pc_node_id in
1989: (
1990: select node.pc_node_id
1991: from ahl_pc_associations assos,
1992: ahl_pc_nodes_b node,
1993: ahl_pc_headers_b hdr
1994: where assos.unit_item_id = l_unit_config_id and
1995: assos.pc_node_id = node.pc_node_id and
1996: node.pc_header_id = hdr.pc_header_id and