DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_RULES_V

Line 6623: okc_rules_v rl

6619: CURSOR c_get_rent_slh_id(c_line_id NUMBER,c_khr_id NUMBER)
6620: IS
6621: SELECT rl.id
6622: FROM okc_rule_groups_v rg,
6623: okc_rules_v rl
6624: WHERE rl.rgp_id = rg.id
6625: AND rl.dnz_chr_id = rg.dnz_chr_id
6626: AND rg.cle_id = c_line_id
6627: AND rg.rgd_code = 'LALEVL'

Line 6636: okc_rules_v rl

6632: CURSOR c_get_freq(c_line_id NUMBER,c_khr_id NUMBER,c_rent_slh_id NUMBER)
6633: IS
6634: SELECT rl.object1_id1 frequency
6635: FROM okc_rule_groups_v rg,
6636: okc_rules_v rl
6637: WHERE rl.rgp_id = rg.id
6638: AND rl.dnz_chr_id = rg.dnz_chr_id
6639: AND rg.cle_id = c_line_id
6640: AND rg.rgd_code = 'LALEVL'