APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKC_RULES_B

Line 19: FROM OKC_RULES_B rul,

15: -----------------------------------------------------------------
16: CURSOR payout_attrs_csr ( p_khr_id NUMBER ) IS
17: SELECT RULE_INFORMATION1,
18: RULE_INFORMATION2
19: FROM OKC_RULES_B rul,
20: Okc_rule_groups_B rgp
21: WHERE rul.rgp_id = rgp.id AND
22: rgp.rgd_code = 'LASEIR' AND
23: rul.rule_information_category = 'LASEIR' AND

Line 77: FROM OKC_RULES_B rul,

73: rul.object2_id1, -- Pay Site
74: rul.OBJECT3_ID1, -- Payment Term
75: RULE_INFORMATION1, -- Payment Method
76: RULE_INFORMATION2 -- Pay Group
77: FROM OKC_RULES_B rul,
78: Okc_rule_groups_B rgp
79: WHERE rul.rgp_id = rgp.id AND
80: rgp.rgd_code = 'LASEDB' AND
81: rul.rule_information_category = 'LASEDB' AND

Line 1300: okc_rules_b rul

1296:
1297: CURSOR inv_code_csr(p_inv_agr_id NUMBER) IS
1298: select RULE_INFORMATION1
1299: from okc_rule_groups_v rgp,
1300: okc_rules_b rul
1301: where rgp.id = rul.rgp_id
1302: and rgp.dnz_chr_id = p_inv_agr_id
1303: and rul.RULE_INFORMATION_CATEGORY = 'LASEAC'
1304: and rgp.RGD_CODE = 'LASEAC';