APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_PC_NODES_B

Line 1779: FROM AHL_PC_NODES_B

1775: -- priyan : bug #5302804
1776: (
1777: -- traverse up the branch, for MEL/CDL, from the PC node being deleted
1778: SELECT PC_NODE_ID
1779: FROM AHL_PC_NODES_B
1780: CONNECT BY PRIOR PARENT_NODE_ID= PC_NODE_ID
1781: START WITH PC_NODE_ID = p_pc_node_id
1782: UNION
1783: -- traverse down the tree, for MEL/CDL, from the PC node being deleted

Line 1785: FROM AHL_PC_NODES_B

1781: START WITH PC_NODE_ID = p_pc_node_id
1782: UNION
1783: -- traverse down the tree, for MEL/CDL, from the PC node being deleted
1784: SELECT PC_NODE_ID
1785: FROM AHL_PC_NODES_B
1786: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID
1787: START WITH PC_NODE_ID = p_pc_node_id
1788: )
1789: AND ROWNUM = 1;

Line 1890: from ahl_pc_nodes_b pcn,

1886: l_mel_cdl_type_code varchar2
1887: )
1888: IS
1889: select mel.mel_cdl_header_id, mel.version_number, pcn.pc_node_id
1890: from ahl_pc_nodes_b pcn,
1891: ahl_mel_cdl_headers mel
1892: --where pcn.pc_node_id = mel.pc_node_id (+) and -- perf fix for bug# 7442102
1893: where pcn.pc_node_id = mel.pc_node_id and
1894: mel.mel_cdl_type_code = l_mel_cdl_type_code and

Line 1902: ahl_pc_nodes_b node,

1898: start with pcn.pc_node_id in
1899: (
1900: select node.pc_node_id
1901: from ahl_pc_associations assos,
1902: ahl_pc_nodes_b node,
1903: ahl_pc_headers_b hdr
1904: where assos.unit_item_id = l_unit_config_id and
1905: assos.pc_node_id = node.pc_node_id and
1906: node.pc_header_id = hdr.pc_header_id and