APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_QUAL_TYPES

Line 591: jtf_qual_types_all jqt

587: IS
588: SELECT NAME
589: FROM JTF_TERR_QTYPE_USGS_all jtqu,
590: jtf_qual_type_usgs_all jqtu ,
591: jtf_qual_types_all jqt
592: WHERE jtqu.terr_id = p_terr_id
593: AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id
594: AND jqt.qual_type_id = jqtu.qual_type_id;
595:

Line 3754: from JTF_QUAL_TYPES jqt

3750: IF ( p_TerrRsc_Access_Rec.ACCESS_TYPE IS NOT NULL AND
3751: p_TerrRsc_Access_Rec.ACCESS_TYPE <> FND_API.G_MISS_CHAR ) THEN
3752: BEGIN
3753: select 'x' into l_Temp
3754: from JTF_QUAL_TYPES jqt
3755: Where jqt.NAME = p_TerrRsc_Access_Rec.ACCESS_TYPE;
3756:
3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN

Line 3761: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');

3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: -- Invalid Territory Id specified
3760: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3761: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3762: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3763: FND_MSG_PUB.ADD;
3764: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3765: END;