APPS.OZF_CHECK_DUP_PROD_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 136: FROM ozf_offer_discount_lines

132: IS
133:
134: CURSOR c_pbh_lines IS
135: SELECT offer_discount_line_id
136: FROM ozf_offer_discount_lines
137: WHERE offer_id = p_offer_id
138: AND tier_type = 'PBH'
139: AND tier_level = 'HEADER';
140:

Line 143: FROM ozf_offer_discount_lines

139: AND tier_level = 'HEADER';
140:
141: CURSOR c_pbh_lines_count IS
142: SELECT COUNT(*)
143: FROM ozf_offer_discount_lines
144: WHERE offer_id = p_offer_id
145: AND tier_type = 'PBH'
146: AND tier_level = 'HEADER';
147: