APPS.AHL_UTIL_PC_PKG dependencies on AHL_PC_ASSOCIATIONS

Line 15: FROM ahl_pc_associations

11:
12: CURSOR get_pc_asso
13: IS
14: SELECT 'X'
15: FROM ahl_pc_associations
16: WHERE pc_node_id IN (
17: SELECT pc_node_id
18: FROM ahl_pc_nodes_b
19: START WITH pc_node_id = p_pc_node_id

Line 53: FROM ahl_pc_associations

49: IS
50: -- SAGARWAL::Bug# 5246104 SQL Id: 17237425
51: /*
52: SELECT 'X'
53: FROM ahl_pc_associations
54: WHERE pc_node_id IN (
55: SELECT pc_node_id
56: FROM ahl_pc_nodes_b
57: CONNECT BY parent_node_id = PRIOR pc_node_id

Line 66: FROM ahl_pc_associations

62: WHERE Csi_Item_Instance_ID = p_Item_Instance_ID)
63: AND association_type_flag='U';
64: */
65: SELECT 'X'
66: FROM ahl_pc_associations
67: WHERE pc_node_id IN (
68: SELECT pc_node_id
69: FROM ahl_pc_nodes_b
70: CONNECT BY parent_node_id = PRIOR pc_node_id

Line 84: FROM ahl_pc_associations

80: IS
81: -- SAGARWAL::Bug# 5246104 SQL Id: 17237441
82: /*
83: SELECT 'X'
84: FROM ahl_pc_associations
85: WHERE pc_node_id IN (
86: SELECT pc_node_id
87: FROM ahl_pc_nodes_b
88: CONNECT BY parent_node_id = PRIOR pc_node_id

Line 97: FROM ahl_pc_associations

93: WHERE Instance_ID = p_Item_Instance_ID)
94: AND association_type_flag='P';
95: */
96: SELECT 'X'
97: FROM ahl_pc_associations
98: WHERE pc_node_id IN (
99: SELECT pc_node_id
100: FROM ahl_pc_nodes_b
101: CONNECT BY parent_node_id = PRIOR pc_node_id

Line 168: AHL_PC_ASSOCIATIONS_V AHASS,

164: MINUS
165: SELECT DISTINCT
166: AHASS.UNIT_ITEM_ID
167: FROM
168: AHL_PC_ASSOCIATIONS_V AHASS,
169: AHL_PC_NODES_B NODE
170: WHERE
171: AHASS.ASSOCIATION_TYPE_FLAG = 'I' AND
172: AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND

Line 197: AHL_PC_ASSOCIATIONS AHS,

193: MINUS
194: SELECT DISTINCT
195: AHS.UNIT_ITEM_ID
196: FROM
197: AHL_PC_ASSOCIATIONS AHS,
198: AHL_PC_NODES_B NODE
199: WHERE
200: AHS.ASSOCIATION_TYPE_FLAG = 'I' AND
201: AHS.PC_NODE_ID = NODE.PC_NODE_ID AND

Line 234: AHL_PC_ASSOCIATIONS_V AHASS,

230: MINUS
231: SELECT
232: AHASS.UNIT_ITEM_ID
233: FROM
234: AHL_PC_ASSOCIATIONS_V AHASS,
235: AHL_PC_NODES_B NODE
236: WHERE
237: AHASS.ASSOCIATION_TYPE_FLAG = 'U' AND
238: AHASS.PC_NODE_ID = NODE.PC_NODE_ID AND

Line 266: AHL_PC_ASSOCIATIONS AHS,

262: MINUS
263: SELECT
264: AHS.UNIT_ITEM_ID
265: FROM
266: AHL_PC_ASSOCIATIONS AHS,
267: AHL_PC_NODES_B NODE
268: WHERE
269: AHS.ASSOCIATION_TYPE_FLAG = 'U' AND
270: AHS.PC_NODE_ID = NODE.PC_NODE_ID AND