APPS.JTF_QUALIFIER_PVT dependencies on JTF_TERR

Line 335: from jtf_terr jta,

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

Line 336: jtf_terr_qual jtq

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

Line 974: FROM JTF_TERR_QUAL

970:
971: /* cursor to check if qualifier usage is used in a territory definition */
972: CURSOR c_chk_terr ( p_qual_usg_id NUMBER ) IS
973: SELECT terr_qual_id
974: FROM JTF_TERR_QUAL
975: WHERE qual_usg_id = p_qual_usg_id;
976:
977: /* cursor to check if qualifier usage is used in a territory type definition */
978: CURSOR c_chk_terr_type ( p_qual_usg_id NUMBER ) IS

Line 980: FROM JTF_TERR_TYPE_QUAL

976:
977: /* cursor to check if qualifier usage is used in a territory type definition */
978: CURSOR c_chk_terr_type ( p_qual_usg_id NUMBER ) IS
979: SELECT terr_type_qual_id
980: FROM JTF_TERR_TYPE_QUAL
981: WHERE qual_usg_id = p_qual_usg_id;
982:
983: /* cursor return variable */
984: dummy_csr NUMBER;