APPS.OKL_REPORT_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 4680: iby_pmt_instr_uses_all pym_instr,

4676: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.start_date, TRUNC (SYSDATE))), -1, 'I',
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

Line 4721: CURSOR validate_bank_account (cp_instrument_payment_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE) IS

4717: rul.rgp_id = rgp.id AND
4718: rul.rule_information_category = 'LABACC';
4719:
4720: -- Validate line level Bank Account in IBY
4721: CURSOR validate_bank_account (cp_instrument_payment_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE) IS
4722: SELECT DECODE (SIGN ( TRUNC (SYSDATE) - pym_instr.start_date),-1, 'I',
4723: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (pym_instr.end_date, TRUNC (SYSDATE))),1, 'I','A')) instr_status,
4724: bnk.bank_account_number,
4725: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (bnk.start_date, TRUNC (SYSDATE))), -1, 'I',

Line 4727: FROM iby_pmt_instr_uses_all pym_instr,

4723: DECODE (SIGN ( TRUNC (SYSDATE)- NVL (pym_instr.end_date, TRUNC (SYSDATE))),1, 'I','A')) instr_status,
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';