APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on JTF_TERR_QUAL_ALL

Line 153: FROM jtf_terr_qual_all

149: WHERE offer_id = p_offer_id;
150:
151: CURSOR c_terr_qual_id(p_terr_id NUMBER) IS
152: SELECT terr_qual_id
153: FROM jtf_terr_qual_all
154: WHERE terr_id = p_terr_id;
155:
156: CURSOR c_country_count(p_terr_qual_id NUMBER) IS
157: SELECT COUNT(1)

Line 2144: jtf_terr_qual_all terr_qual,

2140:
2141: CURSOR c_terr_countries ( p_offer_id IN NUMBER) IS
2142: SELECT terr_val.low_value_char
2143: FROM ozf_offer_qualifiers offer_qual,
2144: jtf_terr_qual_all terr_qual,
2145: jtf_terr_values_all terr_val
2146: WHERE offer_qual.offer_id = p_offer_id
2147: AND offer_qual.qualifier_attr_value = terr_qual.terr_id
2148: AND terr_qual.qual_usg_id = -1065 -- Pick Country Qualifier only