APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_DEAL_SUBTYPES

Line 153: select deal_subtype from xtr_deal_subtypes

149: p_user_deal_subtype VARCHAR2)
150: RETURN VARCHAR2 IS
151:
152: cursor deal_subtype is
153: select deal_subtype from xtr_deal_subtypes
154: where user_deal_subtype = p_user_deal_subtype
155: and deal_type = 'EXP'; --p_deal_type; -- fails with different user deal types
156:
157: v_deal_subtype VARCHAR2(7);

Line 283: from xtr_deal_subtypes_v

279: --in the table
280:
281: CURSOR deal_subtype IS
282: select COUNT(*)
283: from xtr_deal_subtypes_v
284: where deal_type='EXP' and authorised='Y'
285: and user_deal_subtype = p_deal_subtype;
286:
287: v_count NUMBER;