APPS.XTR_FPS3_P dependencies on XTR_JOURNALS

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'