DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on ENG_CHANGE_RULE_ATTRIBUTES_VL

Line 574: FROM eng_change_policies p, eng_change_policy_values pv, eng_change_rules r, eng_change_rule_attributes_vl ra

570: abort_implementation exception;
571:
572: Cursor cur_item_change_not_allowed IS
573: SELECT pv.policy_char_value, r.attribute_number_value, ra.attribute_code
574: FROM eng_change_policies p, eng_change_policy_values pv, eng_change_rules r, eng_change_rule_attributes_vl ra
575: WHERE p.policy_object_pk1_value = l_item_catalog_cat_id
576: and p.policy_object_pk2_value = l_item_lifecycle_id
577: and p.policy_object_pk3_value = l_item_current_phase_id
578: AND pv.POLICY_CHAR_VALUE='NOT_ALLOWED'