APPS.OKL_REPORT_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 4681: iby_pmt_instr_uses_all pym_instr,

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

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

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

Line 4728: FROM iby_pmt_instr_uses_all pym_instr,

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