[Home] [Help]
20: BEGIN
21:
22: SELECT pv.policy_char_value
23: INTO x_policy_value
24: from eng_change_rule_attributes_vl ra,
25: eng_change_rules r,
26: eng_change_policy_values pv,
27: eng_change_policies p
28: where
73: from
74: ( select decode( pv.policy_char_value, 'NOT_ALLOWED', 30,
75: 'CHANGE_ORDER_REQUIRED', 20,
76: 10) restrict_id
77: from eng_change_rule_attributes_vl ra,
78: eng_change_rules r,
79: eng_change_policy_values pv,
80: eng_change_policies p
81: where