APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_SOURCES_ALL

Line 1267: JTF_SOURCES_ALL JSA

1263: SELECT JSA.RSC_LOV_SQL
1264: INTO l_rsc_lov_sql
1265: FROM JTF_TERR_ALL JTA,
1266: JTF_TERR_USGS_ALL JTU,
1267: JTF_SOURCES_ALL JSA
1268: WHERE JTA.TERR_ID = P_TerrRsc_Rec.Terr_Id
1269: AND JTA.TERR_ID = JTU.TERR_ID
1270: AND JTU.SOURCE_ID = JSA.SOURCE_ID;
1271:

Line 1350: JTF_SOURCES_ALL JSA

1346: INTO l_rsc_lov_sql
1347: FROM JTF_TERR_ALL JTA,
1348: JTF_TERR_RSC_ALL JTR,
1349: JTF_TERR_USGS_ALL JTU,
1350: JTF_SOURCES_ALL JSA
1351: WHERE JTR.terr_rsc_id = P_TerrRsc_Rec.Terr_Rsc_Id
1352: AND JTR.TERR_ID = JTA.Terr_Id
1353: AND JTA.TERR_ID = JTU.TERR_ID
1354: AND JTU.SOURCE_ID = JSA.SOURCE_ID;

Line 3775: from jtf_sources_all)

3771: SELECT 'X' INTO l_Temp
3772: FROM ( select DISTINCT lookup_code LOOKUP_CODE
3773: from fnd_lookups
3774: where lookup_type IN ( select rsc_access_lkup
3775: from jtf_sources_all)
3776: )
3777: WHERE LOOKUP_CODE = p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE;
3778: EXCEPTION
3779: WHEN NO_DATA_FOUND THEN