DBA Data[Home] [Help]

APPS.JTF_TERR_CNR_GROUPS_PVT dependencies on JTF_TERR_VALUES_ALL

Line 590: from JTF_TERR_VALUES_ALL jtva

586: and rownum < 2;
587:
588: CURSOR c_cnrgroupid IS
589: select 1
590: from JTF_TERR_VALUES_ALL jtva
591: where jtva.CNR_GROUP_ID = p_Terr_cnr_group_rec.CNR_GROUP_ID
592: and rownum < 2;
593:
594: CURSOR c_cnrgroupname_update IS

Line 603: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq

599: and rownum < 2;
600:
601: CURSOR c_qualifier_defined IS
602: select 1
603: from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
604: where jtq.qual_usg_id = -1102
605: and jtv.terr_qual_id = jtq.terr_qual_id
606: and jtv.low_value_char_id = p_Terr_cnr_group_rec.CNR_GROUP_ID
607: and rownum < 2;