DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_COUNTERPARTY_LIMITS_V

Line 1140: from xtr_counterparty_limits_v a,

1136:
1137: BEGIN
1138: select count(*)
1139: into l_count
1140: from xtr_counterparty_limits_v a,
1141: xtr_limit_types_v b
1142: where a.company_code = p_company_code
1143: and (a.cparty_code = p_acceptor_code or a.cparty_code = p_endorser_code or a.cparty_code = p_drawer_code)
1144: and a.limit_code <> 'SETTLE'

Line 1645: from xtr_counterparty_limits_v a,

1641: /*------------------------------------------------------------------------------------------*/
1642:
1643: CURSOR GET_RISKPARTY_CODE IS
1644: select a.cparty_code
1645: from xtr_counterparty_limits_v a,
1646: xtr_limit_types_v b
1647: where a.company_code = G_Ni_Main_Rec.company_code
1648: and (a.cparty_code = G_Ni_Main_Rec.acceptor_code
1649: or a.cparty_code = G_Ni_Main_Rec.endorser_code