[Home] [Help]
28: FROM okc_actions_v acn,okc_action_attributes_v aae
29: WHERE acn.id = aae.acn_id
30: AND acn.correlation = 'SHR_ADATE_REC' ;
31:
32: -- The following cursor has been changed by MSENGUPT on 12/08/2001 to replace okc_rules_v to okc_rules_b
33: --Select the rule attributes for the time value id
34: CURSOR rul_cur(p_rtve_id IN NUMBER) IS
35: select rul.id rule_id,
36: rul.dnz_chr_id,
34: CURSOR rul_cur(p_rtve_id IN NUMBER) IS
35: select rul.id rule_id,
36: rul.dnz_chr_id,
37: rul.rule_information1 rule_name
38: from okc_resolved_timevalues res, okc_rules_b rul
39: where res.id = p_rtve_id
40: and to_char(res.tve_id) = rul.rule_information2
41: and rul.rule_information_category = 'NTN';
42: