APPS.RCV_DISTRIBUTIONS_S dependencies on PO_LOOKUP_CODES

Line 63: l_lookup_type po_lookup_codes.lookup_type%TYPE;

59: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
60: --
61:
62: /* Bug 3816908 : Variable added */
63: l_lookup_type po_lookup_codes.lookup_type%TYPE;
64:
65: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
66: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
67: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not

Line 375: FROM po_lookup_codes

371: l_lookup_type := 'RCV DESTINATION TYPE';
372:
373: SELECT displayed_field
374: INTO X_destination_type_dsp
375: FROM po_lookup_codes
376: WHERE lookup_type = l_lookup_type
377: AND lookup_code = X_destination_type_code;
378:
379: END IF;