APPS.AHL_PC_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 1647: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

1643: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for Node ID='||l_node_tbl(i));
1644: END IF;
1645:
1646: -- Knocking off Doc Associations
1647: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
1648: WHERE DOC_TITLE_ASSO_ID IN (
1649: SELECT DOC_TITLE_ASSO_ID
1650: FROM AHL_DOC_TITLE_ASSOS_B
1651: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and

Line 2326: FROM AHL_DOC_TITLE_ASSOS_TL

2322: l_linked_node_id := GET_LINKED_NODE_ID(l_node_tbl(j));
2323:
2324: -- Knocking off doc associations from PC nodes...
2325: DELETE
2326: FROM AHL_DOC_TITLE_ASSOS_TL
2327: WHERE DOC_TITLE_ASSO_ID IN (
2328: SELECT DOC_TITLE_ASSO_ID
2329: FROM AHL_DOC_TITLE_ASSOS_B
2330: WHERE aso_object_type_code = 'PC' and

Line 3291: FROM AHL_DOC_TITLE_ASSOS_TL

3287: IF l_draft_nodeId_tbl.count > 0 THEN
3288:
3289: FORALL I IN 1..l_comp_nodeId_tbl.count
3290: DELETE
3291: FROM AHL_DOC_TITLE_ASSOS_TL
3292: WHERE DOC_TITLE_ASSO_ID IN (
3293: SELECT DOC_TITLE_ASSO_ID
3294: FROM AHL_DOC_TITLE_ASSOS_B
3295: WHERE aso_object_type_code = 'PC' and