APPS.XTR_EFT_SCRIPT_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 220: from XTR_DEAL_DATE_AMOUNTS_V d,

216: --
217: -- Header Block
218: cursor HEADER_REC is
219: select distinct d.account_no
220: from XTR_DEAL_DATE_AMOUNTS_V d,
221: XTR_BANK_ACCOUNTS b,
222: XTR_SETTLEMENT_SCRIPTS s
223: -- RV 2305918 where d.actual_settlement_date = NVL(to_date(settlement_date,'DD-MON-RR'), d.actual_settlement_date)
224: where d.actual_settlement_date = NVL(trunc(settlement_date), d.actual_settlement_date)

Line 508: update XTR_DEAL_DATE_AMOUNTS d

504: --
505: IF xtr_risk_debug_pkg.g_Debug THEN
506: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>UPDATE dda table');
507: END IF;
508: update XTR_DEAL_DATE_AMOUNTS d
509: set d.SETTLEMENT_ACTIONED = 'Y',
510: d.SETTLEMENT_ACTIONED_FILE = l_file_name
511: -- RV 2305918 where d.actual_settlement_date = NVL(to_date(settlement_date,'DD-MON-RR'), d.actual_settlement_date)
512: where d.actual_settlement_date = NVL(trunc(settlement_date), d.actual_settlement_date)

Line 692: from xtr_deal_date_amounts x

688:
689:
690: cursor correct_counterparty is
691: select count(*)
692: from xtr_deal_date_amounts x
693: where x.settlement_number = v_settlement_number
694: and ((x.beneficiary_account_no is not null and v_cparty = x.beneficiary_party)
695: or
696: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));

Line 700: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

696: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));
697:
698: cursor correct_counterparty_net is
699: select count(*)
700: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
701: xtr_settlement_summary s2
702: where s1.settlement_number = v_settlement_number
703: and s1.settlement_summary_id = s2.net_id
704: and s2.settlement_number = x.settlement_number

Line 711: from xtr_deal_date_amounts x

707: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));
708:
709: cursor settlement_actioned is
710: select count(*)
711: from xtr_deal_date_amounts x
712: where x.settlement_number = v_settlement_number
713: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
714:
715: cursor settlement_actioned_net is

Line 717: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

713: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
714:
715: cursor settlement_actioned_net is
716: select count(*)
717: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
718: xtr_settlement_summary s2
719: where s1.settlement_number = v_settlement_number
720: and s1.settlement_summary_id = s2.net_id
721: and s2.settlement_number = x.settlement_number

Line 727: FROM xtr_deal_date_amounts

723:
724: --bug 3195086
725: cursor get_groupid(p_netid VARCHAR2) is
726: SELECT netoff_number
727: FROM xtr_deal_date_amounts
728: where settlement_number = (select settlement_number
729: from xtr_settlement_summary
730: WHERE net_id = p_netid
731: and ROWNUM=1);

Line 879: update XTR_DEAL_DATE_AMOUNTS d

875:
876: fnd_profile.get('CONC_REQUEST_ID', v_request_id);
877:
878: if v_netcount > 0 then
879: update XTR_DEAL_DATE_AMOUNTS d
880: set d.SETTLEMENT_ACTIONED = 'Y',
881: d.SETTLEMENT_ACTIONED_FILE = l_file_name
882: where SETTLEMENT_NUMBER in
883: (select settlement_number from xtr_settlement_summary x

Line 886: update XTR_DEAL_DATE_AMOUNTS d

882: where SETTLEMENT_NUMBER in
883: (select settlement_number from xtr_settlement_summary x
884: where x.net_id = v_settlement_summary_id);
885: else
886: update XTR_DEAL_DATE_AMOUNTS d
887: set d.SETTLEMENT_ACTIONED = 'Y',
888: d.SETTLEMENT_ACTIONED_FILE = l_file_name
889: where SETTLEMENT_NUMBER = v_settlement_number;
890: end if;

Line 1008: from xtr_deal_date_amounts x

1004: where x.net_id = v_settlement_summary_id;
1005:
1006: cursor settlement_actioned is
1007: select count(*)
1008: from xtr_deal_date_amounts x
1009: where x.settlement_number = v_settlement_number
1010: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
1011:
1012: cursor settlement_actioned_net is

Line 1014: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

1010: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
1011:
1012: cursor settlement_actioned_net is
1013: select count(*)
1014: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1015: xtr_settlement_summary s2
1016: where s1.settlement_number = v_settlement_number
1017: and s1.settlement_summary_id = s2.net_id
1018: and s2.settlement_number = x.settlement_number

Line 1023: from xtr_deal_date_amounts x

1019: and ((upper(sett) = 'Y') OR (x.settlement_actioned is null));
1020:
1021: cursor correct_counterparty is
1022: select count(*)
1023: from xtr_deal_date_amounts x
1024: where x.settlement_number = v_settlement_number
1025: and ((x.beneficiary_account_no is not null and v_cparty = x.beneficiary_party)
1026: or
1027: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));

Line 1031: from xtr_deal_date_amounts x, xtr_settlement_summary s1,

1027: (x.beneficiary_account_no is null and v_cparty = x.cparty_code));
1028:
1029: cursor correct_counterparty_net is
1030: select count(*)
1031: from xtr_deal_date_amounts x, xtr_settlement_summary s1,
1032: xtr_settlement_summary s2
1033: where s1.settlement_number = v_settlement_number
1034: and s1.settlement_summary_id = s2.net_id
1035: and s2.settlement_number = x.settlement_number

Line 1205: update XTR_DEAL_DATE_AMOUNTS d

1201:
1202: fnd_profile.get('CONC_REQUEST_ID', v_request_id);
1203:
1204: if v_netcount > 0 then
1205: update XTR_DEAL_DATE_AMOUNTS d
1206: set d.SETTLEMENT_ACTIONED = 'Y',
1207: d.SETTLEMENT_ACTIONED_FILE = l_file_name
1208: where SETTLEMENT_NUMBER in
1209: (select settlement_number from xtr_settlement_summary x

Line 1212: update XTR_DEAL_DATE_AMOUNTS d

1208: where SETTLEMENT_NUMBER in
1209: (select settlement_number from xtr_settlement_summary x
1210: where x.net_id = v_settlement_summary_id);
1211: else
1212: update XTR_DEAL_DATE_AMOUNTS d
1213: set d.SETTLEMENT_ACTIONED = 'Y',
1214: d.SETTLEMENT_ACTIONED_FILE = l_file_name
1215: where SETTLEMENT_NUMBER = v_settlement_number;
1216: end if;