DBA Data[Home] [Help]

APPS.XTR_UPDATE_SETTLEMENT_ACCOUNTS dependencies on XTR_PARTIES_V

Line 75: from xtr_parties_v where party_type = 'C';

71: IS
72:
73: CURSOR company_list IS
74: select party_code
75: from xtr_parties_v where party_type = 'C';
76:
77: CURSOR max_deal_no IS
78: select max (deal_number) from XTR_DEAL_DATE_AMOUNTS;
79:

Line 202: FROM xtr_bank_accounts xban, xtr_parties_v xpv

198: /* for bug 5634804*/
199:
200: SELECT xban.currency, xpv.party_type
201: INTO l_current_currency, l_party_type
202: FROM xtr_bank_accounts xban, xtr_parties_v xpv
203: WHERE xban.account_number = p_current_bank_account
204: AND xban.party_code = p_party_code
205: AND xpv.party_code = xban.party_code;
206: