APPS.ENG_CHANGE_POLICY_PKG dependencies on ENG_CHANGE_RULES

Line 25: eng_change_rules r,

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
29: p.policy_object_name = p_policy_object_name

Line 78: eng_change_rules r,

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
82: p.policy_object_name = 'CATALOG_LIFECYCLE_PHASE'