DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 4682: iby_ext_bank_accounts_v bnk

4678: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.end_date, TRUNC (SYSDATE))), 1, 'I','A') ) bnk_status
4679: FROM okc_rules_b rul,
4680: okc_rule_groups_b rgp,
4681: iby_pmt_instr_uses_all pym_instr,
4682: iby_ext_bank_accounts_v bnk
4683: WHERE rul.rgp_id = rgp.id
4684: AND rgp.rgd_code = 'LABILL'
4685: AND rgp.dnz_chr_id = rgp.chr_id
4686: AND rgp.dnz_chr_id = cp_khr_id

Line 4729: iby_ext_bank_accounts_v bnk

4725: bnk.bank_account_number,
4726: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.start_date, TRUNC (SYSDATE))), -1, 'I',
4727: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.end_date, TRUNC (SYSDATE))), 1, 'I','A') ) bnk_status
4728: FROM iby_pmt_instr_uses_all pym_instr,
4729: iby_ext_bank_accounts_v bnk
4730: WHERE pym_instr.instrument_payment_use_id = cp_instrument_payment_use_id
4731: AND pym_instr.instrument_id = bnk.bank_account_id
4732: AND pym_instr.instrument_type = 'BANKACCOUNT';
4733: