APPS.XTR_FPS3_P dependencies on XTR_DEAL_DATE_AMOUNTS

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 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'