APPS.JTF_TERRITORY_PVT dependencies on JTF_TERR_TYPES_ALL

Line 1370: FROM jtf_terr_types_all a,

1366: -- Check if the Terr Type is valid for the given source.
1367: BEGIN
1368: SELECT 1
1369: INTO l_dummy
1370: FROM jtf_terr_types_all a,
1371: jtf_terr_type_usgs_all b
1372: WHERE a.enabled_flag = 'Y'
1373: AND a.terr_type_id = b.terr_type_id
1374: AND a.org_id = b.org_id

Line 6411: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TERRITORY_TYPE_ID, 'TERR_TYPE_ID', 'JTF_TERR_TYPES_ALL');

6407: --
6408: If (p_Terr_All_Rec.TERRITORY_TYPE_ID is not null) AND
6409: (p_Terr_All_Rec.TERRITORY_TYPE_ID <> FND_API.G_MISS_NUM)
6410: then
6411: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TERRITORY_TYPE_ID, 'TERR_TYPE_ID', 'JTF_TERR_TYPES_ALL');
6412: If l_status <> FND_API.G_TRUE Then
6413: x_return_status := FND_API.G_RET_STS_ERROR;
6414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6415: --dbms_output('TERR TYPE: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');