DBA Data[Home] [Help]

APPS.XTR_MAINTAIN_DDA_P dependencies on XTR_BOND_ISSUES

Line 203: from XTR_BOND_ISSUES

199: where s.CURRENCY = c_currency;
200:
201: cursor CHK_ISSUE is
202: select YEAR_BASIS,CALC_TYPE,RIC_CODE
203: from XTR_BOND_ISSUES
204: where BOND_ISSUE_CODE = P_BOND_ISSUE
205: and AUTHORISED = 'Y'
206: and ((ISSUER=P_COMPANY_CODE and P_DEAL_SUBTYPE='ISSUE') or P_DEAL_SUBTYPE<>'ISSUE')
207: and nvl(BOND_OR_DEBENTURE_ISSUE,'B') = 'B';