APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKC_RULE_GROUPS_B

Line 477: OKC_RULE_GROUPS_B RGP

473:
474: CURSOR GET_PMNT_ARREAR_FLAG(P_KHR_ID IN NUMBER, P_KLE_ID IN NUMBER) IS
475: SELECT RL.RULE_INFORMATION10
476: FROM OKC_RULES_B RL,
477: OKC_RULE_GROUPS_B RGP
478: WHERE RL.RULE_INFORMATION_CATEGORY = 'LASLL'
479: AND RL.RGP_ID = RGP.ID
480: AND RGP.RGD_CODE = 'LALEVL'
481: AND RGP.CLE_ID = P_KLE_ID

Line 872: AND exists (select 1 from okc_rule_groups_b rgp

868: AND khs.ste_code = 'ACTIVE'
869: AND stm.kle_id = kle.id(+)
870: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
871: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
872: AND exists (select 1 from okc_rule_groups_b rgp
873: , okc_rules_b rul
874: where rgp.dnz_chr_id = kle.dnz_chr_id
875: and rgp.cle_id = kle.id
876: and rgp.rgd_code = 'LAASTX'