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 1691: jtf_terr_qual_all terr_qual,

1687:
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