DBA Data[Home] [Help]

APPS.XTR_EFT_SCRIPT_P dependencies on XTR_EFT_CREDITS_V

Line 270: from XTR_EFT_CREDITS_V d,

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