eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_FPS3_P dependencies on XTR_DEALS

Line 738: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

734: p_out_rec IN OUT NOCOPY validation_out_rec) IS
735: cursor bond_coupon_settled(p_bond_issue_code VARCHAR2,
736: p_coupon_date DATE) is
737: select 1
738: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
739: where rt.deal_number=d.deal_no
740: and d.bond_issue=p_bond_issue_code
741: and rt.maturity_date=p_coupon_date
742: and dda.settle='Y'

Line 752: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

748: or (rt.principal_tax_settled_ref is not null
749: and dda.transaction_number=rt.principal_tax_settled_ref))
750: UNION ALL
751: select 1
752: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
753: where rt.deal_number=d.deal_no
754: and d.bond_issue=p_bond_issue_code
755: and rt.maturity_date=p_coupon_date
756: and dda.settle='Y'

Line 764: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

760: and dda.deal_type='BOND';
761:
762: cursor bond_coupon_settled_all(p_bond_issue_code VARCHAR2) is
763: select 1
764: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
765: where rt.deal_number=d.deal_no
766: and d.bond_issue=p_bond_issue_code
767: and dda.settle='Y'
768: and rt.deal_type='BOND'

Line 777: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

773: or (rt.principal_tax_settled_ref is not null
774: and dda.transaction_number=rt.principal_tax_settled_ref))
775: UNION ALL
776: select 1
777: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
778: where rt.deal_number=d.deal_no
779: and d.bond_issue=p_bond_issue_code
780: and dda.settle='Y'
781: and rt.deal_type='BOND'

Line 815: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j

811: p_out_rec IN OUT NOCOPY validation_out_rec) IS
812: cursor bond_coupon_journaled (p_bond_issue_code VARCHAR2,
813: p_coupon_date DATE) is
814: select 1
815: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
816: where rt.deal_number=d.deal_no
817: and d.bond_issue=p_bond_issue_code
818: and rt.maturity_date=p_coupon_date
819: and j.orig_journal_date is not null

Line 829: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j

825: or (rt.principal_tax_settled_ref is not null
826: and j.transaction_number=rt.principal_tax_settled_ref))
827: UNION ALL
828: select 1
829: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
830: where rt.deal_number=d.deal_no
831: and d.bond_issue=p_bond_issue_code
832: and rt.maturity_date=p_coupon_date
833: and j.orig_journal_date is not null

Line 841: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j

837: and rt.transaction_number=j.transaction_number;
838:
839: cursor bond_coupon_journaled_all (p_bond_issue_code VARCHAR2) is
840: select 1
841: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
842: where rt.deal_number=d.deal_no
843: and d.bond_issue=p_bond_issue_code
844: and j.orig_journal_date is not null
845: and rt.deal_type='BOND'

Line 854: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j

850: or (rt.principal_tax_settled_ref is not null
851: and j.transaction_number=rt.principal_tax_settled_ref))
852: UNION ALL
853: select 1
854: from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
855: where rt.deal_number=d.deal_no
856: and d.bond_issue=p_bond_issue_code
857: and j.orig_journal_date is not null
858: and rt.deal_type='BOND'

Line 892: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

888: p_out_rec IN OUT NOCOPY validation_out_rec) IS
889: cursor bond_coupon_reconciled (p_bond_issue_code VARCHAR2,
890: p_coupon_date DATE) is
891: select 1
892: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
893: where rt.deal_number=d.deal_no
894: and d.bond_issue=p_bond_issue_code
895: and rt.maturity_date=p_coupon_date
896: and dda.reconciled_reference is not null

Line 906: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

902: or (rt.principal_tax_settled_ref is not null
903: and dda.transaction_number=rt.principal_tax_settled_ref))
904: UNION ALL
905: select 1
906: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
907: where rt.deal_number=d.deal_no
908: and d.bond_issue=p_bond_issue_code
909: and rt.maturity_date=p_coupon_date
910: and dda.reconciled_reference is not null

Line 918: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

914: and dda.deal_type='BOND';
915:
916: cursor bond_coupon_reconciled_all (p_bond_issue_code VARCHAR2) is
917: select 1
918: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
919: where rt.deal_number=d.deal_no
920: and d.bond_issue=p_bond_issue_code
921: and dda.reconciled_reference is not null
922: and rt.deal_type='BOND'

Line 931: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda

927: or (rt.principal_tax_settled_ref is not null
928: and dda.transaction_number=rt.principal_tax_settled_ref))
929: UNION ALL
930: select 1
931: from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
932: where rt.deal_number=d.deal_no
933: and d.bond_issue=p_bond_issue_code
934: and dda.reconciled_reference is not null
935: and rt.deal_type='BOND'

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: