DBA Data[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on ENG_CHANGE_TYPE_PRIORITIES

Line 164: ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,

160: cursor priority_code(p_change_order_type_id NUMBER
161: )is
162: SELECT TypePriorityCodeEO.PRIORITY_CODE
163: FROM
164: ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,
165: ENG_CHANGE_PRIORITIES WHERE
166: TypePriorityCodeEO.CHANGE_TYPE_ID = p_change_order_type_id AND
167: TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE
168: AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1