APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on JTF_TERR_VALUES_ALL

Line 158: FROM jtf_terr_values_all

154: WHERE terr_id = p_terr_id;
155:
156: CURSOR c_country_count(p_terr_qual_id NUMBER) IS
157: SELECT COUNT(1)
158: FROM jtf_terr_values_all
159: WHERE low_value_char = p_country_code
160: AND terr_qual_id = p_terr_qual_id;
161:
162: l_customer_qualified VARCHAR2(1);

Line 2145: jtf_terr_values_all terr_val

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
2149: AND terr_qual.terr_qual_id = terr_val.terr_qual_id;