DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_LIMIT_TYPES_V

Line 1141: xtr_limit_types_v b

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'
1145: and a.limit_type = b.limit_type

Line 1646: xtr_limit_types_v b

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
1650: or a.cparty_code = G_Ni_Main_Rec.drawer_code)