APPS.AP_APPROVAL_PKG dependencies on AP_LOOKUP_CODES

Line 5173: FROM ap_lookup_codes

5169:
5170: UPDATE ap_holds
5171: SET release_lookup_code = l_release_lookup_code,
5172: release_reason = (SELECT description
5173: FROM ap_lookup_codes
5174: WHERE lookup_code = l_release_lookup_code
5175: AND lookup_type = 'HOLD CODE'),
5176: last_update_date = sysdate,
5177: last_updated_by = 5,

Line 5312: FROM ap_lookup_codes

5308: substrb(nvl(p_hold_reason, description),1,240),
5309: 'S',
5310: g_org_id, /* Bug 3700128. MOAC Project */
5311: l_hold_id -- Added for Negotiation.
5312: FROM ap_lookup_codes
5313: WHERE lookup_code = p_hold_lookup_code
5314: AND lookup_type = 'HOLD CODE');
5315:
5316: --