DBA Data[Home] [Help]

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_SEEDED_QUAL_USGS_V

Line 4015: FROM jtf_seeded_qual_usgs_v jsquv, JTF_TERR_QUAL JTQ

4011: v_Terr_Qual_Id number;
4012:
4013: CURSOR c_Terr_ResQual IS
4014: SELECT JTQ.TERR_QUAL_ID
4015: FROM jtf_seeded_qual_usgs_v jsquv, JTF_TERR_QUAL JTQ
4016: WHERE JTQ.terr_id = p_Terr_id and
4017: JTQ.qual_usg_id = jsquv.qual_usg_id and
4018: jsquv.qual_type_id = -1001 and
4019: jsquv.qual_type_id in ( select related_id

Line 4031: from jtf_seeded_qual_usgs_v jsquv, jtf_terr_values jtv, jtf_terr_qual jtq

4027: jtv.low_value_number, jtv.high_value_number,
4028: jtv.INTEREST_TYPE_ID, jtv.PRIMARY_INTEREST_CODE_ID,
4029: jtv.SECONDARY_INTEREST_CODE_ID, jsquv.DISPLAY_TYPE, jsquv.CONVERT_TO_ID_FLAG,
4030: jtv.ID_USED_FLAG, jtv.CURRENCY_CODE, jtv.LOW_VALUE_CHAR_ID
4031: from jtf_seeded_qual_usgs_v jsquv, jtf_terr_values jtv, jtf_terr_qual jtq
4032: where jtv.terr_qual_id = v_Terr_Qual_Id and
4033: jtv.terr_qual_id = jtq.terr_qual_id and
4034: jtq.qual_usg_id = jsquv.qual_usg_id;
4035: