DBA Data[Home] [Help]

APPS.XTR_FPS3_P dependencies on XTR_ACCRLS_AMORT

Line 969: from xtr_rollover_transactions rt, xtr_accrls_amort a, xtr_deals d

965: p_out_rec IN OUT NOCOPY validation_out_rec) IS
966: cursor bond_coupon_accrued (p_bond_issue_code VARCHAR2,
967: p_coupon_date DATE) is
968: select 1
969: from xtr_rollover_transactions rt, xtr_accrls_amort a, xtr_deals d
970: where rt.deal_number=a.deal_no
971: and rt.transaction_number=a.trans_no
972: and d.deal_no=rt.deal_number
973: and d.bond_issue=p_bond_issue_code

Line 978: from xtr_accrls_amort a, xtr_deals d

974: and rt.maturity_date=p_coupon_date;
975:
976: cursor bond_coupon_accrued_all (p_bond_issue_code VARCHAR2) is
977: select 1
978: from xtr_accrls_amort a, xtr_deals d
979: where amount_type='CPMADJ'
980: and d.deal_no=a.deal_no
981: and d.bond_issue=p_bond_issue_code;
982: