DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on ENG_CHANGE_RULE_ATTRIBUTES_VL

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

642: abort_implementation exception;
643:
644: Cursor cur_item_change_not_allowed IS
645: SELECT pv.policy_char_value, r.attribute_number_value, ra.attribute_code
646: FROM eng_change_policies p, eng_change_policy_values pv, eng_change_rules r, eng_change_rule_attributes_vl ra
647: WHERE p.policy_object_pk1_value = l_item_catalog_cat_id
648: and p.policy_object_pk2_value = l_item_lifecycle_id
649: and p.policy_object_pk3_value = l_item_current_phase_id
650: AND pv.POLICY_CHAR_VALUE='NOT_ALLOWED'