DBA Data[Home] [Help]

APPS.XTR_EFT_SCRIPT_P dependencies on XTR_EFT_DEBITS_V

Line 246: from XTR_EFT_DEBITS_V d,

242: substr(d.cparty_account_no,4,4)||substr(d.cparty_account_no,9,7)||
243: substr(d.cparty_account_no,17)||spce||'50'||spce||to_char(abs(d.settle_amount * 100))||
244: spce||p.short_name||spce||spce||spce||spce||q.short_name||spce||
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)