APPS.AP_APPROVAL_PKG dependencies on AP_LOOKUP_CODES

Line 6948: FROM ap_lookup_codes

6944:
6945: UPDATE ap_holds
6946: SET release_lookup_code = l_release_lookup_code,
6947: release_reason = (SELECT description
6948: FROM ap_lookup_codes
6949: WHERE lookup_code = l_release_lookup_code
6950: AND lookup_type = 'HOLD CODE'),
6951: last_update_date = sysdate,
6952: last_updated_by = 5,

Line 7122: FROM ap_lookup_codes

7118: substrb(nvl(p_hold_reason, description),1,240),
7119: 'S',
7120: nvl(g_org_id,l_org_id), /* Bug 3700128. MOAC Project */
7121: l_hold_id -- Added for Negotiation.
7122: FROM ap_lookup_codes
7123: WHERE lookup_code = p_hold_lookup_code
7124: AND lookup_type = 'HOLD CODE');
7125:
7126: --