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 1692: jtf_terr_values_all terr_val

1688: CURSOR c_terr_countries ( p_offer_id IN NUMBER) IS
1689: SELECT terr_val.low_value_char
1690: FROM ozf_offer_qualifiers offer_qual,
1691: jtf_terr_qual_all terr_qual,
1692: jtf_terr_values_all terr_val
1693: WHERE offer_qual.offer_id = p_offer_id
1694: AND offer_qual.qualifier_attr_value = terr_qual.terr_id
1695: AND terr_qual.qual_usg_id = -1065 -- Pick Country Qualifier only
1696: AND terr_qual.terr_qual_id = terr_val.terr_qual_id;