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: