DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_AUTH_DEAL_SUBTYPES_V

Line 1048: from xtr_auth_deal_subtypes_v a,

1044: --* Note : Deal_subtype column in the view is actually referring to the user_deal_subtype of the table.
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