DBA Data[Home] [Help]

APPS.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on AMS_CELLS_VL

Line 1337: FROM ams_cells_vl

1333: l_cell_name VARCHAR2(120);
1334:
1335: CURSOR c_cell_rec(l_cell_id NUMBER) IS
1336: SELECT cell_id, market_segment_flag,cell_name
1337: FROM ams_cells_vl
1338: WHERE cell_id = l_cell_id
1339: OR (parent_cell_id = l_cell_id
1340: AND market_segment_flag = 'N' );
1341:

Line 1344: FROM ams_cells_vl ;

1340: AND market_segment_flag = 'N' );
1341:
1342: CURSOR c_all_cell_rec IS
1343: SELECT cell_id, market_segment_flag ,cell_name
1344: FROM ams_cells_vl ;
1345:
1346: CURSOR c_sql_id(cell_id IN NUMBER) IS
1347: SELECT workbook_name,workbook_owner,worksheet_name
1348: FROM ams_act_discoverer_all