APPS.OKL_REPORT_PVT dependencies on OKC_RULES_B

Line 4556: FROM OKC_RULES_B rul,

4552:
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

Line 4568: FROM OKC_RULES_B rul,

4564: -- Line Level Payment method
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

Line 4580: , OKC_RULES_B rul

4576: SELECT rul.object1_id1
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

Line 4678: FROM okc_rules_b rul,

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

Line 4695: FROM OKC_RULES_B rul,

4691: -- Derive Line level Bank Account
4692: CURSOR cust_line_bank_csr ( cp_khr_id NUMBER,
4693: cp_kle_id NUMBER ) IS
4694: SELECT object1_id1
4695: FROM OKC_RULES_B rul,
4696: Okc_rule_groups_B rgp
4697: WHERE rul.rgp_id = rgp.id AND
4698: rgp.cle_id = cp_kle_id AND
4699: rgp.rgd_code = 'LABILL' AND

Line 4707: , OKC_RULES_B rul

4703: SELECT rul.object1_id1
4704: FROM okc_k_lines_b cle
4705: , okc_k_items_v item
4706: , okc_k_lines_b linked_asset
4707: , OKC_RULES_B rul
4708: , Okc_rule_groups_B rgp
4709: WHERE cle.dnz_chr_id = cp_khr_id AND
4710: cle.id = cp_kle_id AND
4711: cle.chr_id IS NULL AND

Line 4800: l_pmth_id1 okc_rules_b.object1_id1%TYPE;

4796: l_ext_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4797: l_party_name okx_parties_v.name%TYPE;
4798: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
4799: l_cust_site_name okx_cust_sites_v.description%TYPE;
4800: l_pmth_id1 okc_rules_b.object1_id1%TYPE;
4801: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;
4802: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;
4803: l_ext_line_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4804: l_rct_line_method_code ar_receipt_classes.creation_method_code%TYPE;

Line 4802: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;

4798: l_ext_addr_id okx_cust_site_uses_v.cust_acct_site_id%TYPE;
4799: l_cust_site_name okx_cust_sites_v.description%TYPE;
4800: l_pmth_id1 okc_rules_b.object1_id1%TYPE;
4801: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;
4802: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;
4803: l_ext_line_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4804: l_rct_line_method_code ar_receipt_classes.creation_method_code%TYPE;
4805: l_account_number hz_cust_accounts.account_number%TYPE;
4806: l_bank_line_id1 okc_rules_b.object1_id1%TYPE;

Line 4806: l_bank_line_id1 okc_rules_b.object1_id1%TYPE;

4802: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;
4803: l_ext_line_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4804: l_rct_line_method_code ar_receipt_classes.creation_method_code%TYPE;
4805: l_account_number hz_cust_accounts.account_number%TYPE;
4806: l_bank_line_id1 okc_rules_b.object1_id1%TYPE;
4807:
4808: l_exists VARCHAR2(1);
4809: l_fetch_size NUMBER := 5000;
4810: