27: If p_code IS NOT NULL
28: THEN
29: OPEN x_codes for
30: SELECT action_code, Description 31: FROM mtl_actions 32: WHERE NVL(disable_flag,'N') = 'N'
33: AND action_code like (p_code);
34: Else
35: OPEN x_codes for
Line 37: FROM mtl_actions
33: AND action_code like (p_code);
34: Else
35: OPEN x_codes for
36: SELECT action_code, Description 37: FROM mtl_actions 38: WHERE NVL(disable_flag,'N') = 'N';
39: END IF;
40:
41: END expiration_action_code;