APPS.OKL_FUNDING_CHECKLIST_PVT dependencies on OKC_RULE_GROUPS_B

Line 431: from okc_rule_groups_b

427:
428: cursor c_rgp_id (chr_id number)
429: is
430: select id
431: from okc_rule_groups_b
432: where rgd_code = G_FUNDING_CHKLST_TPL--'LAFCLH'
433: and dnz_chr_id = chr_id;
434:
435: begin

Line 766: l_rgpv_id okc_rule_groups_b.id%type;

762: l_lease_app_found_str VARCHAR2(10);
763: l_lease_app_list_found_str VARCHAR2(10);
764: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
765: l_chr_id okc_k_headers_b.id%type := OKC_API.G_MISS_NUM;
766: l_rgpv_id okc_rule_groups_b.id%type;
767: l_grp_row_not_found boolean;
768: lp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
769: lx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
770: x_lease_app_id number;

Line 777: from okc_rule_groups_b rgp

773: -- Funded contract group
774: ---------------------------------------------------------------------------------------------------
775: cursor c_grp (p_chr_id number) is
776: select rgp.id
777: from okc_rule_groups_b rgp
778: where rgp.dnz_chr_id = p_chr_id
779: and rgp.RGD_CODE = G_FUNDING_CHKLST_TPL
780: ;
781: --END: Fixed bug 5912358 by nikshah, 06-MAR-2007