APPS.XTR_EFT_SCRIPT_P dependencies on XTR_BANK_ACCOUNTS

Line 221: XTR_BANK_ACCOUNTS b,

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)
225: and d.company_code = l_company

Line 249: XTR_BANK_ACCOUNTS b

245: 'Ref '||rtrim(l_file_name)||spce
246: from XTR_EFT_DEBITS_V d,
247: XTR_PARTIES_V p,
248: XTR_PARTIES_V q,
249: XTR_BANK_ACCOUNTS b
250: -- 2305918 where d.actual_settlement_date = NVL(to_date(settlement_date,'DD-MON-RR'), d.actual_settlement_date)
251: where d.actual_settlement_date = NVL(trunc(settlement_date), d.actual_settlement_date)
252: and d.account_no = comp_acct
253: and d.company_code = l_company

Line 273: XTR_BANK_ACCOUNTS b

269: spce||q.short_name||spce||'Ref '||rtrim(l_file_name)||spce
270: from XTR_EFT_CREDITS_V d,
271: XTR_PARTIES_V p,
272: XTR_PARTIES_V q,
273: XTR_BANK_ACCOUNTS b
274: --2305918 where d.actual_settlement_date = NVL(to_date(settlement_date,'DD-MON-RR'), d.actual_settlement_date)
275: where d.actual_settlement_date = NVL(trunc(settlement_date), d.actual_settlement_date)
276: and d.account_no = comp_acct
277: and d.company_code = l_company

Line 521: from XTR_BANK_ACCOUNTS b,

517: and d.trans_mts = 'Y'
518: and d.settle = 'Y'
519: and ((upper(sett) = 'Y') or (upper(sett) = 'N' and d.settlement_actioned is NULL))
520: and d.account_no = (select distinct b.account_number
521: from XTR_BANK_ACCOUNTS b,
522: XTR_SETTLEMENT_SCRIPTS s
523: where b.account_number = d.account_no
524: and b.party_code = upper(l_company)
525: and SUBSTR(b.eft_script_name,1,4) = l_eft_script_name --RV

Line 655: XTR_BANK_ACCOUNTS b,

651: -- Gets applicable bank accounts
652: cursor HEADER_REC is
653: select distinct sw.company_acct_no
654: from XTR_SWIFT_EFT_V sw,
655: XTR_BANK_ACCOUNTS b,
656: XTR_SETTLEMENT_SCRIPTS s
657: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
658: and sw.company = l_company
659: and sw.cparty = nvl(l_cparty,sw.cparty)

Line 973: XTR_BANK_ACCOUNTS b,

969: -- Gets applicable bank accounts
970: cursor HEADER_REC is
971: select distinct sw.company_acct_no
972: from XTR_SWIFT_EFT_V sw,
973: XTR_BANK_ACCOUNTS b,
974: XTR_SETTLEMENT_SCRIPTS s
975: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
976: and sw.company = l_company
977: and sw.cparty = nvl(l_cparty,sw.cparty)