DBA Data[Home] [Help]

APPS.OKL_FUNDING_CHECKLIST_PVT dependencies on OKC_RULES_B

Line 764: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;

760: l_lease_app_found boolean := FALSE;
761: l_lease_app_list_found boolean := FALSE;
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;

Line 1355: from okc_rules_b a

1351:
1352: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE, p_req_id number)
1353: is
1354: select a.id
1355: from okc_rules_b a
1356: where a.dnz_chr_id = p_chr_id
1357: -- Sep-26-2005 cklee -- Fixed ORA-01722: invalid number for |
1358: -- approve_funding_chklst function cursor issue |
1359: --and a.object1_id1 = p_req_id