APPS.POS_COMPARE_REVISIONS dependencies on PO_UN_NUMBERS

Line 64: * PO_UN_NUMBERS table.

60: * Resolves the UN number.
61: *
62: * ARGUMENTS
63: * p_un_number_id Unique identifier for UN number in
64: * PO_UN_NUMBERS table.
65: *
66: * NOTES
67: * Return NULL if an error occurs.
68: *

Line 76: v_un_number po_un_numbers.un_number%TYPE;

72: ********************************************************************/
73: FUNCTION get_un_number( p_un_number_id IN NUMBER )
74: RETURN VARCHAR2 AS
75:
76: v_un_number po_un_numbers.un_number%TYPE;
77: v_progress VARCHAR2(3);
78:
79: BEGIN
80:

Line 85: FROM po_un_numbers

81: v_progress := '020';
82:
83: SELECT un_number
84: INTO v_un_number
85: FROM po_un_numbers
86: WHERE un_number_id = p_un_number_id;
87:
88: RETURN v_un_number;
89: