[Home] [Help]
1070: where deal_type = 'NI'
1071: and product_auth = 'Y'
1072: and product_type = p_product_type
1073: and product_type in(select product_type
1074: from xtr_auth_product_types_v
1075: where deal_type='NI'
1076: and deal_subtype=p_deal_subtype);
1077:
1078: return (l_count>0);