APPS.FA_RX_LOV_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  procedure unparse_lov_select (
	X_lovid		number,
	X_params	fa_rx_lov_pkg.param_array,
	X_param_types	fa_rx_lov_pkg.param_array,
	X_num_params	number,
	X_select out nocopy clob,
	X_missing_param out nocopy number) is

  h_sqlstmt	clob;

Line: 20

    select select_statement
    into h_sqlstmt
    from fa_rx_lov
    where lov_id = X_lovid;

Line: 64

    X_select := h_sqlstmt;

Line: 66

  end unparse_lov_select;