DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_RULES_V

Line 7221: okc_rules_v rl

7217: CURSOR c_get_rent_slh_id(c_line_id NUMBER,c_khr_id NUMBER)
7218: IS
7219: SELECT rl.id
7220: FROM okc_rule_groups_v rg,
7221: okc_rules_v rl
7222: WHERE rl.rgp_id = rg.id
7223: AND rl.dnz_chr_id = rg.dnz_chr_id
7224: AND rg.cle_id = c_line_id
7225: AND rg.rgd_code = 'LALEVL'

Line 7234: okc_rules_v rl

7230: CURSOR c_get_freq(c_line_id NUMBER,c_khr_id NUMBER,c_rent_slh_id NUMBER)
7231: IS
7232: SELECT rl.object1_id1 frequency
7233: FROM okc_rule_groups_v rg,
7234: okc_rules_v rl
7235: WHERE rl.rgp_id = rg.id
7236: AND rl.dnz_chr_id = rg.dnz_chr_id
7237: AND rg.cle_id = c_line_id
7238: AND rg.rgd_code = 'LALEVL'