APPS.AMS_CELL_PVT dependencies on AMS_DISCOVERER_SQL

Line 1298: FROM ams_discoverer_sql

1294: l_from_position NUMBER := 0;
1295:
1296: CURSOR c_discoverer_cell is
1297: SELECT workbook_owner_name, workbook_name, worksheet_name
1298: FROM ams_discoverer_sql
1299: WHERE discoverer_sql_id = l_discoverer_sql_id;
1300:
1301: l_discoverer_cell_rec c_discoverer_cell%ROWTYPE;
1302:

Line 1307: FROM ams_discoverer_sql

1303: CURSOR c_discoverer_sql (p_workbook_name IN VARCHAR2,
1304: p_worksheet_name IN VARCHAR2,
1305: p_workbook_owner_name IN VARCHAR2) IS
1306: SELECT sql_string, sequence_order
1307: FROM ams_discoverer_sql
1308: WHERE workbook_name = p_workbook_name
1309: AND worksheet_name = p_worksheet_name
1310: AND workbook_owner_name = p_workbook_owner_name
1311: ORDER BY sequence_order;

Line 1742: FROM ams_discoverer_sql

1738: CURSOR c_discoverer_sql (p_workbook_name IN VARCHAR2,
1739: p_worksheet_name IN VARCHAR2,
1740: p_workbook_owner_name IN VARCHAR2) IS
1741: SELECT sql_string, sequence_order
1742: FROM ams_discoverer_sql
1743: WHERE workbook_name = p_workbook_name
1744: AND worksheet_name = p_worksheet_name
1745: AND workbook_owner_name = p_workbook_owner_name
1746: ORDER BY sequence_order;

Line 2230: FROM ams_discoverer_sql

2226: l_sql_string VARCHAR2(20000) := '';
2227:
2228: CURSOR c_discoverer (p_disc_sql_id IN NUMBER) IS
2229: SELECT workbook_name, worksheet_name, workbook_owner_name
2230: FROM ams_discoverer_sql
2231: WHERE discoverer_sql_id = p_disc_sql_id;
2232:
2233: l_discoverer_rec c_discoverer%ROWTYPE;
2234:

Line 2239: FROM ams_discoverer_sql

2235: CURSOR c_discoverer_sql (p_workbook_name IN VARCHAR2,
2236: p_worksheet_name IN VARCHAR2,
2237: p_workbook_owner_name IN VARCHAR2) IS
2238: SELECT sql_string, sequence_order
2239: FROM ams_discoverer_sql
2240: WHERE workbook_name = p_workbook_name
2241: AND worksheet_name = p_worksheet_name
2242: AND workbook_owner_name = p_workbook_owner_name
2243: ORDER BY sequence_order;