APPS.AHL_OSP_ACCOMP_PVT dependencies on DUAL

Line 778: SELECT c_instance_id from DUAL

774: AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
775: AND tld.transaction_line_id = tl.transaction_line_id;
776:
777: CURSOR get_instance_descendants_csr (c_instance_id NUMBER) IS
778: SELECT c_instance_id from DUAL
779: UNION
780: SELECT subject_id from csi_ii_relationships
781: WHERE relationship_type_code = 'COMPONENT-OF'
782: AND NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE