[Home] [Help]
4553: -- K level Payment method
4554: CURSOR cust_pmth_csr ( p_khr_id IN NUMBER ) IS
4555: SELECT object1_id1
4556: FROM OKC_RULES_B rul,
4557: Okc_rule_groups_B rgp
4558: WHERE rul.rgp_id = rgp.id AND
4559: rgp.rgd_code = 'LABILL' AND
4560: rgp.dnz_chr_id = rgp.chr_id AND
4561: rul.rule_information_category = 'LAPMTH' AND
4565: CURSOR cust_line_pmth_csr ( p_khr_id IN NUMBER,
4566: p_kle_id IN NUMBER ) IS
4567: SELECT object1_id1
4568: FROM OKC_RULES_B rul,
4569: Okc_rule_groups_B rgp
4570: WHERE rul.rgp_id = rgp.id AND
4571: rgp.rgd_code = 'LABILL' AND
4572: rgp.cle_id = p_kle_id AND
4573: rul.rule_information_category = 'LAPMTH' AND
4577: FROM okc_k_lines_b cle
4578: , okc_k_items_v item
4579: , okc_k_lines_b linked_asset
4580: , OKC_RULES_B rul
4581: , Okc_rule_groups_B rgp
4582: WHERE cle.dnz_chr_id = p_khr_id AND
4583: cle.id = p_kle_id AND
4584: cle.chr_id IS NULL AND
4585: cle.id = item.cle_id AND
4676: bnk.bank_account_number,
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'
4693: CURSOR cust_line_bank_csr ( cp_khr_id NUMBER,
4694: cp_kle_id NUMBER ) IS
4695: SELECT object1_id1
4696: FROM OKC_RULES_B rul,
4697: Okc_rule_groups_B rgp
4698: WHERE rul.rgp_id = rgp.id AND
4699: rgp.cle_id = cp_kle_id AND
4700: rgp.rgd_code = 'LABILL' AND
4701: rul.rule_information_category = 'LABACC' AND
4705: FROM okc_k_lines_b cle
4706: , okc_k_items_v item
4707: , okc_k_lines_b linked_asset
4708: , OKC_RULES_B rul
4709: , Okc_rule_groups_B rgp
4710: WHERE cle.dnz_chr_id = cp_khr_id AND
4711: cle.id = cp_kle_id AND
4712: cle.chr_id IS NULL AND
4713: cle.id = item.cle_id AND