APPS.AHL_PC_HEADER_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 1569: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

1565: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_AND_TREE -- Handling force delete for Node ID='||l_node_tbl(i));
1566: END IF;
1567:
1568: -- Knocking off Doc Associations
1569: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
1570: WHERE DOC_TITLE_ASSO_ID IN (
1571: SELECT DOC_TITLE_ASSO_ID
1572: FROM AHL_DOC_TITLE_ASSOS_B
1573: WHERE ASO_OBJECT_TYPE_CODE = 'PC' and

Line 2172: FROM AHL_DOC_TITLE_ASSOS_TL

2168: l_linked_node_id := GET_LINKED_NODE_ID(l_node_tbl(j));
2169:
2170: -- Knocking off doc associations from PC nodes...
2171: DELETE
2172: FROM AHL_DOC_TITLE_ASSOS_TL
2173: WHERE DOC_TITLE_ASSO_ID IN (
2174: SELECT DOC_TITLE_ASSO_ID
2175: FROM AHL_DOC_TITLE_ASSOS_B
2176: WHERE aso_object_type_code = 'PC' and

Line 3067: FROM AHL_DOC_TITLE_ASSOS_TL

3063: IF l_draft_nodeId_tbl.count > 0 THEN
3064:
3065: FORALL I IN 1..l_comp_nodeId_tbl.count
3066: DELETE
3067: FROM AHL_DOC_TITLE_ASSOS_TL
3068: WHERE DOC_TITLE_ASSO_ID IN (
3069: SELECT DOC_TITLE_ASSO_ID
3070: FROM AHL_DOC_TITLE_ASSOS_B
3071: WHERE aso_object_type_code = 'PC' and