APPS.JTF_TERR_ASSIGN_PUB dependencies on JTF_TERR_DENORM_RULES_ALL
Line 169: FROM jtf_terr_denorm_rules_all jtdr
165: /* ARPATEL: Sales records are no longer striped by tx type */
166: if p_source_id = -1001 then
167: SELECT COUNT(*)
168: INTO l_num_of_terr 169: FROM jtf_terr_denorm_rules_all jtdr 170: WHERE jtdr.source_id = p_source_id
171: AND rownum < 2;
172: else
173: SELECT COUNT(*)
Line 175: FROM jtf_terr_denorm_rules_all jtdr
171: AND rownum < 2;
172: else
173: SELECT COUNT(*)
174: INTO l_num_of_terr 175: FROM jtf_terr_denorm_rules_all jtdr 176: WHERE jtdr.source_id = p_source_id
177: AND rownum < 2;
178: end if;
179: