APPS.JTF_QUALIFIER_PVT dependencies on JTF_TERR

Line 338: from jtf_terr jta,

334: BEGIN
335:
336: select 1
337: into l_count
338: from jtf_terr jta,
339: jtf_terr_qual jtq
340: where jta.terr_id = jtq.terr_id
341: and jtq.qual_usg_id = l_qual_usg_id
342: and rownum < 2;

Line 339: jtf_terr_qual jtq

335:
336: select 1
337: into l_count
338: from jtf_terr jta,
339: jtf_terr_qual jtq
340: where jta.terr_id = jtq.terr_id
341: and jtq.qual_usg_id = l_qual_usg_id
342: and rownum < 2;
343:

Line 983: FROM JTF_TERR_QUAL

979:
980: /* cursor to check if qualifier usage is used in a territory definition */
981: CURSOR c_chk_terr ( p_qual_usg_id NUMBER ) IS
982: SELECT terr_qual_id
983: FROM JTF_TERR_QUAL
984: WHERE qual_usg_id = p_qual_usg_id;
985:
986: /* cursor to check if qualifier usage is used in a territory type definition */
987: CURSOR c_chk_terr_type ( p_qual_usg_id NUMBER ) IS

Line 989: FROM JTF_TERR_TYPE_QUAL

985:
986: /* cursor to check if qualifier usage is used in a territory type definition */
987: CURSOR c_chk_terr_type ( p_qual_usg_id NUMBER ) IS
988: SELECT terr_type_qual_id
989: FROM JTF_TERR_TYPE_QUAL
990: WHERE qual_usg_id = p_qual_usg_id;
991:
992: /* cursor return variable */
993: dummy_csr NUMBER;