APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_DEAL_SUBTYPES

Line 1030: from xtr_deal_subtypes

1026: /*--------------------------------------------------------------------------------*/
1027: l_count NUMBER;
1028: cursor get_deal_subtype is
1029: select deal_subtype
1030: from xtr_deal_subtypes
1031: where deal_type = 'NI'
1032: and user_deal_subtype = p_user_deal_subtype
1033: and nvl(authorised,'N') = 'Y'
1034: and rownum = 1;

Line 1049: xtr_deal_subtypes b

1045: ------------------------------------------------------------------------------------------------------
1046: select count(*)
1047: into l_count
1048: from xtr_auth_deal_subtypes_v a,
1049: xtr_deal_subtypes b
1050: where a.deal_type = 'NI'
1051: and a.deal_type = b.deal_type
1052: and a.deal_subtype = b.user_deal_subtype
1053: and b.deal_subtype in ('BUY','ISSUE')

Line 1512: from xtr_deal_subtypes

1508: v_err_level VARCHAR2(2) := ' ';
1509:
1510: cursor get_tolerance is
1511: select tolerance
1512: from xtr_deal_subtypes
1513: where deal_type='NI'
1514: and deal_subtype=g_ni_deal_subtype;
1515:
1516: BEGIN