DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 4681: iby_ext_bank_accounts_v bnk

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

Line 4728: iby_ext_bank_accounts_v bnk

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