APPS.CN_FORMULA_GEN_PKG dependencies on CN_SOURCE_ALL

Line 5070: FROM cn_source_all cs

5066:
5067:
5068: CURSOR pkg_start (c_object_id NUMBER, c_org_id NUMBER) IS
5069: SELECT cs.line_no, cs.text
5070: FROM cn_source_all cs
5071: WHERE cs.object_id = c_object_id
5072: AND cs.org_id = c_org_id
5073: AND SUBSTR(cs.text,1,25) = 'CREATE OR REPLACE PACKAGE'
5074: ORDER BY cs.line_no;

Line 5080: FROM cn_source_all cs

5076: l_pkg_start_rec pkg_start%ROWTYPE;
5077:
5078: CURSOR pkg_end (c_object_id NUMBER, c_org_id NUMBER) IS
5079: SELECT cs.line_no, cs.text
5080: FROM cn_source_all cs
5081: WHERE cs.object_id = c_object_id
5082: AND cs.org_id = c_org_id
5083: AND cs.text like 'END%'
5084: ORDER BY cs.line_no DESC;

Line 5090: FROM cn_source_all cs

5086: l_pkg_end_rec pkg_end%ROWTYPE;
5087:
5088: CURSOR fetch_code (c_object_id NUMBER, c_pkg_str NUMBER, c_pkg_end NUMBER) IS
5089: SELECT cs.text
5090: FROM cn_source_all cs
5091: WHERE cs.object_id = c_object_id
5092: AND cs.line_no BETWEEN c_pkg_str and c_pkg_end
5093: ORDER BY cs.line_no;
5094: