APPS.AS_GAR_QOT_PUB dependencies on ASO_TERRITORY_ACCESSES

Line 1340: INSERT INTO ASO_TERRITORY_ACCESSES

1336: END IF;
1337: BEGIN
1338: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1339: FORALL i IN l_first .. l_last
1340: INSERT INTO ASO_TERRITORY_ACCESSES
1341: ( access_id,
1342: territory_id,
1343: last_update_date,
1344: last_updated_by,

Line 1375: FROM ASO_TERRITORY_ACCESSES AST

1371: AND A.resource_id=l_resource_id(i)
1372: ) AA
1373: WHERE NOT EXISTS
1374: (SELECT 'X'
1375: FROM ASO_TERRITORY_ACCESSES AST
1376: WHERE AST.access_id = AA.acc_id
1377: AND AST.territory_id = l_terr_id(i))
1378: ) V
1379: );

Line 1424: FROM ASO_TERRITORY_ACCESSES AST

1420: AND A.resource_id=l_resource_id(i)
1421: ) AA
1422: WHERE NOT EXISTS
1423: (SELECT 'X'
1424: FROM ASO_TERRITORY_ACCESSES AST
1425: WHERE AST.access_id = AA.acc_id
1426: AND AST.territory_id = l_terr_id(i))
1427: ) V
1428: );