APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_RULE_GROUPS_B

Line 2875: okc_rule_groups_b rgpb,

2871: CURSOR adv_arr_csr IS
2872: SELECT
2873: rulb2.RULE_INFORMATION10 arrears_yn
2874: FROM okc_k_lines_b cleb,
2875: okc_rule_groups_b rgpb,
2876: okc_rules_b rulb,
2877: okc_rules_b rulb2,
2878: okl_strm_type_b styb
2879: WHERE rgpb.chr_id IS NULL

Line 7233: CURSOR l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

7229: l_cap_amnt NUMBER := 0;
7230: l_pcnt_inv NUMBER := 0;
7231: l_stake_amnt NUMBER := 0;
7232:
7233: CURSOR l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
7234: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
7235: chrId NUMBER) IS
7236: SELECT crl.object1_id1,
7237: crl.RULE_INFORMATION1,

Line 7245: FROM OKC_RULE_GROUPS_B crg,

7241: crl.RULE_INFORMATION5,
7242: crl.RULE_INFORMATION6,
7243: crl.RULE_INFORMATION10,
7244: crl.RULE_INFORMATION11
7245: FROM OKC_RULE_GROUPS_B crg,
7246: OKC_RULES_B crl
7247: WHERE crl.rgp_id = crg.id
7248: AND crg.RGD_CODE = rgcode
7249: AND crl.RULE_INFORMATION_CATEGORY = rlcat

Line 7425: ,okc_rule_groups_b rgpb

7421: CURSOR l_okl_inv_payment_event_csr(p_khr_id IN NUMBER)
7422: IS
7423: SELECT rulb.rule_information2 payment_event
7424: FROM okc_rules_b rulb
7425: ,okc_rule_groups_b rgpb
7426: WHERE rgpb.dnz_chr_id = p_khr_id
7427: AND rgpb.chr_id = p_khr_id
7428: AND rgpb.rgd_code = 'LASEIR'
7429: AND rgpb.id = rulb.rgp_id

Line 12531: FROM okc_rule_groups_b lalevl,

12527: END IF;
12528:
12529: SELECT TO_NUMBER(laslh.object1_id1)
12530: INTO l_fee_payment_id
12531: FROM okc_rule_groups_b lalevl,
12532: okc_rules_b laslh
12533: WHERE lalevl.cle_id = p_contract_line_id
12534: AND lalevl.rgd_code = 'LALEVL'
12535: AND lalevl.id = laslh.rgp_id